to_date problem. - Mailing list pgsql-bugs

From lewwid
Subject to_date problem.
Date
Msg-id 5Z5474CAZY6ZXQL3Z508D82GA873.3d0829b1@Jeff
Whole thread Raw
Responses Re: to_date problem.
List pgsql-bugs
select to_date('December 12 2002','Month dd yyyy');
  to_date
------------
 2002-12-02

select to_date('January 12 2002','Month dd yyyy');
  to_date
------------
 0005-06-24     <----- Problem right there.


select to_date('January 12, 2002','Month dd, yyyy');
  to_date
------------
 2002-01-01   <-- It should be 2002-01-12

select to_date('December 12, 2002','Month dd yyyy');
  to_date
------------
 2002-12-02


For some reason it's getting caught up on January.  I know these dates are
Unambiguous however I think there might be a bug there.

It would be my first bug ;)

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Bug #691: CREATE TABLE AS ignores explicit column names with UNION
Next
From: Jeff
Date:
Subject: to_date bug