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
"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 FMMon
am Fri, dem 07.09.2007, um 17:22:30 +1200 mailte anru chen folgendes:
> Hi all:
>
> i am use postgres 8.2 on windows XP, following select statement
>
> "select to_date('10 August 2007','DD Month ');"
> return me 0007-08-10,
>
> if i do "select to_date('10 September 2007','DD Month ');"
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
On Behalf Of anru chen
Sent: Friday, 7 September 2007 15:23
To: pgsql-sql@postgresql.org
Subject: [SQL] to_date function
> Hi all:
>
> i am use postgres 8.2 on windows XP, following select statement
>
>
Hi all:
i am use postgres 8.2 on windows XP, following select statement
"select to_date('10 August 2007','DD Month ');"
return me 0007-08-10,
if i do "select to_date('10 September 2007','DD Month ');"
result is correct 2007-09-10
seems like "to_date" function only work correctly for cur
