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

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Wed, 24 Mar 2004 11:57:26 -0600
Message-ID: <gui36059inkvdkg85cqf3ssso7qatftl28@4ax.com>

"Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote:

>
>"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
>

That does not explain the 'assumption' Oracle is making, that you want the 1st day of the current month for the year indicated...Why does it even query SYSDATE??? Received on Wed Mar 24 2004 - 11:57:26 CST