Postgres Pro
Downloads
Home   >   mailing lists

Thread: Money Data Type

Money Data Type

From
Len Morgan
Date:
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

Re: [SQL] Money Data Type

From
"Jose' Soares Da Silva"
Date:
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'