Thread: to_date problem.

to_date problem.

From

lewwid

Date:

13 June 2002, 04:12:19

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 ;)

Re: to_date problem.

From

Tom Lane

Date:

13 June 2002, 13:34:50

lewwid <lewwid@telusplanet.net> writes:
> select to_date('January 12 2002','Month dd yyyy');
>   to_date
> ------------
>  0005-06-24     <----- Problem right there.

I think you need FM:

regression=# select to_date('January 12 2002','FMMonth dd yyyy');
  to_date
------------
 2002-01-12
(1 row)

Without that, the to_date scanner assumes it should be dealing with
fixed-width fields.  I think this is moderately broken myself, but
maybe that's the way Oracle does it...

            regards, tom lane