am Fri, dem 07.09.2007, um 10:25:57 -0400 mailte Tom Lane folgendes: > "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
Oh, cool, it works. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
