On 1/5/2010 10:54 AM, Tom Lane wrote:
> Adrian Klaver<aklaver(at)comcast(dot)net> 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