to_date bug - Mailing list pgsql-bugs

From Jeff
Subject to_date bug
Date
Msg-id 41EDB404Y2W72LF2WP2ZPJKIWS98.3d077cdd@Jeff
Whole thread Raw
Responses Re: to_date bug  (Karel Zak <zakkr@zf.jcu.cz>)
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: lewwid
Date:
Subject: to_date problem.
Next
From: Chris Sutton
Date:
Subject: select real returns nothing