to_date function

From: "anru chen" <ctx2002(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: to_date function
Date: 2007-09-07 05:22:30
Message-ID: 9bb664980709062222n13f66543kf621094604a9944e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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,

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Phillip Smith 2007-09-07 06:17:49 Re: to_date function
Previous Message Jean-David Beyer 2007-09-06 11:45:41 Re: How to use serial variable to insert into muiti-recrods?