| 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 |
| Views: | Whole Thread | Raw Message | 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 ;)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2002-06-12 17:16:42 | Re: [BUGS] createdb comments |
| Previous Message | Bruce Momjian | 2002-06-12 16:40:29 | Re: [BUGS] Bug #640: ECPG: inserting float numbers |