Date fields before Year 2000.

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 Thu Mar 16 2000 - 00:00:00 CST