Thread

1. Money Data Type

   Len Morgan <len-morgan@xroadstx.com> — 1998-06-03T16:55:21Z

   I am having a problem converting a data type of money to type float.
   After 'greping' all the documentation directorys, I can't find a
   reference to
   "money", "Money", or "MONEY" but I know it's in there somewhere because
   I have a money type (a mistake I now realize) in my database.
   
   How do I convert from type money to type float and back?
   
   float4(moneyfield) gives me a huge number (something e+09).  I get
   similar
   results with float8, float, and even int4().
   
   Thanks in advance.
   
   Len Morgan
   
   
   

2. Re: [SQL] Money Data Type

   jose' soares <sferac@bo.nettuno.it> — 1998-06-04T10:23:52Z

   On Wed, 3 Jun 1998, Len Morgan wrote:
   
   > I am having a problem converting a data type of money to type float.
   > After 'greping' all the documentation directorys, I can't find a
   > reference to
   > "money", "Money", or "MONEY" but I know it's in there somewhere because
   > I have a money type (a mistake I now realize) in my database.
   > 
   > How do I convert from type money to type float and back?
   > 
   > float4(moneyfield) gives me a huge number (something e+09).  I get
   > similar
   > results with float8, float, and even int4().
   > 
   CAST (yMONEY AS float4)
   CAST (yMONEY AS float8)
   CAST (yMONEY AS int2)
   CAST (yMONEY AS int4)
                                                               Ciao, Jose'