| From: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | Re: to_date function |
| Date: | 2007-09-07 17:41:00 |
| Message-ID: | 20070907174100.GA29185@a-kretschmer.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
am Fri, dem 07.09.2007, um 10:25:57 -0400 mailte Tom Lane folgendes:
> "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)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
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | novice | 2007-09-09 01:06:49 | Re: work hour calculations |
| Previous Message | Richard Huxton | 2007-09-07 14:38:23 | Re: SERIAL type's sequence is double-called or ? |