Thread: money format

money format

From
Haris Susanto
Date:
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@dnet.net.id