"A. Kretschmer" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
