Guy Rouillier <guyr-ml1@burntmail.com> writes:
> 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."
*Toggles* the effect of the modifier? Egad, what drunken idiot chose
that specification?
That's certainly not how PG is interpreting the FM modifier --- we
suppose it applies to just the specifier it's attached to. Still,
we generally assume that Oracle is the authoritative reference for
how to_char() ought to behave, so maybe we should hold our noses
and change it. Problem is that this would inevitably break
practically every existing use of to_date with FM :-( (not to mention
the other modifiers, which I suppose behave that way too?)
Anyway, your example clearly shows that FM ought to strip leading
zeroes in YY, so that change ought to get made.
regards, tom lane