| From: | Haris Susanto <hariss(at)dnet(dot)net(dot)id> |
|---|---|
| To: | pgsql-sql-digest <pgsql-sql(at)hub(dot)org> |
| Subject: | money format |
| Date: | 1999-08-26 08:37:21 |
| Message-ID: | 13650.990826@dnet.net.id |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Hello pgsql-sql-digest,
I want to ask about currency format in PostgreSQL. Suppose I have a
table like this :
my_money (data type : int)
--------
10000
20000
30000
In which way I can query those record in currency format. But please
don't ask me to convert the data type into money type, coz it means
put me into big trouble ! :)
What I want is like these :
10.000 or 10.000,- or 10.000,00
20.000 or 20.000,- or 20.000,00
30.000 or 30.000,- or 30.000,00
I hope somebody will give me advice.
Thanks in advanced.
Best regards,
Haris mailto:hariss(at)dnet(dot)net(dot)id
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brandon Huey | 1999-08-26 09:51:48 | join expression support in 6.5.1? |
| Previous Message | Michael Richards | 1999-08-26 06:28:58 | Re: [SQL] 2 million+ entries |