Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: select to_date('2004','YYYY') NOT Jan 1 2004

Re: select to_date('2004','YYYY') NOT Jan 1 2004

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Wed, 24 Mar 2004 16:18:06 GMT
Message-ID: <2xi8c.82903$Cb.1101266@attbi_s51>

"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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US