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

On Wed, 24 Mar 2004 13:40:10 -0500, "Jarson" <jarsonk_at_nospam.com> wrote:

>You shouldn't have to (albeit this is the point of the argument and very
>easy to work around). I didn't specify the day of the month, hour, minute
>or second either as these default to each value's start, as expected.
>
>I expected that if you tell the to_date function to convert just the year,
>it would interpret as the "start of the year". If instead as it uses the
>current month as a default, then I would expect it to also use the current
>day, hour, minute and second; but it does not.

That's one reason careful programmers don't rely on defaults. Another is that defaults have been known to change as products evolve.

-- 
Mike Sherrill
Information Management Systems