"Jarson" <jarsonk_at_nospam.com> wrote in message
news:pdi8c.18858$A_2.978850_at_news20.bellglobal.com...
> When I run the following SQL
>
> SQL> select to_date('2004','YYYY') from dual ;
>
> The result is 01-Mar-04. I was expecting 01-Jan-04.
> Is it returning March because that is the current month, or does it always
> return March? Does anyone else get this (I'm on Oracle 8.1.6)?
>
> Jarson
>
>
Why? You have only specified the year and not the month and the day. If
you want 1/1/2004 then specify that.
Jim
Received on Wed Mar 24 2004 - 10:18:06 CST
