Re: to_date function

"A. Kretschmer" <andreas.kretschmer@schollglas.com> writes:
> am  Fri, dem 07.09.2007, um 17:22:30 +1200 mailte anru chen folgendes:
>> seems like "to_date" function only work correctly for current month.

> No, seems like to_char only work corrently if the length of the month
> correctly...

You need to use FMMonth not Month if you want it to be lax about the
width of the month field.  (I think we decided that's a bug and 8.3
will take it either way, but existing releases want the FM.)
        regards, tom lane