| From: | "Jose' Soares Da Silva" <sferac(at)bo(dot)nettuno(dot)it> |
|---|---|
| To: | Len Morgan <len-morgan(at)xroadstx(dot)com> |
| Cc: | pgsql-sql(at)postgreSQL(dot)org |
| Subject: | Re: [SQL] Money Data Type |
| Date: | 1998-06-04 10:23:52 |
| Message-ID: | Pine.LNX.3.96.980604102140.945D-100000@proxy.bazzanese.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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'
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jose' Soares Da Silva | 1998-06-04 10:26:50 | Re: [SQL] desc and asc |
| Previous Message | ATTILIO FERRARI PAWLIKOWSKI | 1998-06-04 10:18:04 | help!!!!!!!!!!! |