Skip site navigation (1) Skip section navigation (2)

Re: function to format floats as money? (removing space padding)

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Mark Stosberg <mark(at)summersault(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: function to format floats as money? (removing space padding)
Date: 2001-04-20 07:54:33
Message-ID: 20010420095432.C21932@ara.zf.jcu.cz (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)zf(dot)jcu(dot)cz>
 http://home.zf.jcu.cz/~zakkr/
 
 C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz

In response to

pgsql-sql by date

Next:From: Peter T MountDate: 2001-04-20 10:54:38
Subject: Re: [SQL] How to store gif or jpeg? Thanks!
Previous:From: Hans-Jürgen SchönigDate: 2001-04-19 23:31:03
Subject: Re: windows version

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group