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

Re: to_char bug?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ben Trewern" <bendottrewern(at)mowlem(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: to_char bug?
Date: 2005-02-28 21:44:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
"Ben Trewern" <bendottrewern(at)mowlem(dot)com> writes:
> It seems that to_char(1, '000') gives a string " 001" with a space in front. 
> Is this a bug?


Possibly you want 'FM000'.

			regards, tom lane

In response to


pgsql-general by date

Next:From: Martijn van OosterhoutDate: 2005-02-28 22:00:32
Subject: Re: Clay Shirky observation regarding MySQL
Previous:From: Shachar ShemeshDate: 2005-02-28 21:09:38
Subject: Re: Unicode support on Win32

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