Skip site navigation (1) Skip section navigation (2)

Re: to_date function

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 (view raw or flat)
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

In response to

pgsql-sql by date

Next:From: noviceDate: 2007-09-09 01:06:49
Subject: Re: work hour calculations
Previous:From: Richard HuxtonDate: 2007-09-07 14:38:23
Subject: Re: SERIAL type's sequence is double-called or ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group