Home > mailing lists

to_date function - Mailing list pgsql-sql

From	anru chen
Subject	to_date function
Date	September 7, 2007 05:22:37
Msg-id	9bb664980709062222n13f66543kf621094604a9944e@mail.gmail.com Whole thread Raw
Responses	Re: to_date function Re: to_date function
List	pgsql-sql

Tree view

Hi all:

i am use postgres 8.2 on windows XP, following select statement

"select to_date('10 August 2007','DD Month YYYY');"
return me 0007-08-10,

if i do "select to_date('10 September 2007','DD Month YYYY');"
result is correct 2007-09-10

seems like "to_date" function only work correctly for current month.
any one know why?

regards,

pgsql-sql by date:

From: Jean-David Beyer
Date: 06 September 2007, 11:46:06
Subject: Re: How to use serial variable to insert into muiti-recrods?

From: "Phillip Smith"
Date: 07 September 2007, 06:24:43
Subject: Re: to_date function

to_date function - Mailing list pgsql-sql

Previous

Next