[SQL] to_date function

[anru chen]

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,

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster