set decimal point in SQL

From: "Bu, Ning" <NBU(at)pcgus(dot)com>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: set decimal point in SQL
Date: 2003-06-16 22:02:34
Message-ID: B0D78FC4B536D6118D5A006097B658DE2A2C45@PCGSSU2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql




I have a field set up as money and I try to calculate some number and put in
this field, but the number will be 6 demical point and I want to cut it to
only 2-4 decimal point, how can I do it? Thanks

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2003-06-16 22:15:46 Our FLOAT(p) precision does not conform to spec
Previous Message Guillaume LELARGE 2003-06-16 19:37:36 Re: UNION & LIMIT & ORDER BY