Re: Date fields before Year 2000.

Hi

What is the NLS_DATE_FORMAT in the database if this is set to dd-mon-yy then 99 is intrepreted as 2099 and not 1999.

HTH
Arvind Balaraman
sumanp_at_my-deja.com wrote in message <8arjrt$7nn$1_at_nnrp1.deja.com>...
>Have you noticed that now (this year),
>the following statement does not work correctly.
>
>select * from table_name
>where date_column = '01-Dec-99';
>
>The above statement does not return
>any rows, even though data is present in
>the table. I can swear that the above
>statement returned rows last year.
>
>But the following statement returns rows.
>
>select * from table_name
>where date_column = to_date('01-Dec-1999', 'dd-mon-yyyy');
>
>Wierd, isn't it?
>I found the same behaviour in Oracle 7.3 and Oracle 8.
>
>Does anybody know why this is happening
>and if we can resolve it in some way.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Fri Mar 17 2000 - 00:00:00 CST