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

to_date bug

From: Jeff <jeff(at)downtown-office(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Cc: lockhart(at)alumni(dot)caltech(dot)edu
Subject: to_date bug
Date: 2002-06-12 16:54:53
Message-ID: 41EDB404Y2W72LF2WP2ZPJKIWS98.3d077cdd@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: Nigel J. AndrewsDate: 2002-06-12 17:16:42
Subject: Re: [BUGS] createdb comments
Previous:From: Bruce MomjianDate: 2002-06-12 16:40:29
Subject: Re: [BUGS] Bug #640: ECPG: inserting float numbers

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