to_date problem.

From: lewwid <lewwid(at)telusplanet(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: to_date problem.
Date: 2002-06-13 05:12:17
Message-ID: 5Z5474CAZY6ZXQL3Z508D82GA873.3d0829b1@Jeff
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ;)

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2002-06-13 14:30:40 Re: to_date problem.
Previous Message Tom Lane 2002-06-13 02:11:26 Re: Bug #691: CREATE TABLE AS ignores explicit column names with UNION