From: Karel Zak <zakkr@zf.jcu.cz>
To: Mark Stosberg <mark@summersault.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: function to format floats as money? (removing space padding)
Date: Fri, 20 Apr 2001 09:54:33 +0200
Message-ID: <20010420095432.C21932@ara.zf.jcu.cz> (raw)
In-Reply-To: <3ADF4218.6604D76C@summersault.com>
References: <Pine.LNX.4.30.0104171724230.762-100000@peter.localdomain>
<3ADC61E0.93E7865D@summersault.com>
<3ADF4218.6604D76C@summersault.com>
On Thu, Apr 19, 2001 at 02:53:38PM -0500, Mark Stosberg wrote:
>
> Now that I've figured out that numeric is good for storing money, and
> that I can format with like this:
>
> to_char(price, '9,999,999.99') as price
>
> Then I discovered that sometimes this returns leading spaces I don't
> want. I can get rid of them like this:
>
> trim(to_char(price, '9,999,999.99')) as price
>
> Is that the recommended money formatting style, for amounts less than
> 9,999,999.99? (assuming I'll tack on my own currency symbol? ). Other
> there other general styles that folks like for this? Thanks,
May be try docs, what? :-)
test=# select to_char(123456, '9,999,999.99');
to_char
---------------
123,456.00
(1 row)
test=# select to_char(123456, 'FM9,999,999.99');
to_char
---------
123,456
(1 row)
test=# select to_char(123456, 'FM9,999,999.00');
to_char
------------
123,456.00
(1 row)
test=# select to_char(123, 'FM0,999,999.00');
to_char
--------------
0,000,123.00
(1 row)
test=# select to_char(123456, 'LFM9,999,999.00');
to_char
------------
$123,456.00
(1 row)
FM ....fill mode, skip blank spaces and zeroes (if not set '0' instead '9')
L ....currency symbol (from actual locales)
Right?
Karel
--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: zakkr@zf.jcu.cz, mark@summersault.com
Subject: Re: function to format floats as money? (removing space padding)
In-Reply-To: <20010420095432.C21932@ara.zf.jcu.cz>
References: <Pine.LNX.4.30.0104171724230.762-100000@peter.localdomain> <3ADC61E0.93E7865D@summersault.com> <3ADF4218.6604D76C@summersault.com> <20010420095432.C21932@ara.zf.jcu.cz>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox