Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group