"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