On 1/5/2010 10:54 AM, Tom Lane wrote:
Adrian Klaver<aklaver@xxxxxxxxxxx> writes:
From what I could see in the source code
(src/backend/utils/adt/formatting.c) the year portion of the string is
not run through the FM modifier. A fix would mean a patch to the above
AFAIK.
Should it be? Can anyone check how this works on Oracle?
Oracle states clearly in the SQL Reference manual:
"A modifier can appear in a format model more than once. In such a case,
each subsequent occurrence toggles the effects of the modifier."
I get the following results:
select to_char(DATE'2009-1-1','FMDD.FMMM.FMYY') from dual;
1.01.9
select to_char(DATE'2009-1-1','FM DD.MM.YY') from dual
1.1.9
--
Guy Rouillier
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
