pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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



view thread (2+ messages)

Message-ID: <20010420095432.C21932@ara.zf.jcu.cz>
Permalink:  ../20010420095432.C21932@ara.zf.jcu.cz/
Also on:    postgresql.org/message-id/20010420095432.C21932@ara.zf.jcu.cz

 · 

reply

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