Horton
Menu

Re: Re: [GENERAL] FM format modifier does not remove leading zero from year

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Alvaro Herrera <alvherre@commandprompt.com>
Cc: Bruce Momjian <bruce@momjian.us>, Guy Rouillier <guyr-ml1@burntmail.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2010-02-08T16:19:10Z
Lists: pgsql-hackers, pgsql-general 
Alvaro Herrera <alvherre@commandprompt.com> writes:
> What's the point of not following Oracle here, since this is solely an
> Oracle compatibility function?

Changing FM's behavior like that will break approximately every user
of to_char() ...

			regards, tom lane