Re: date data type and = operator

Andrew is right, but this is simpler:
select *
from table1
where trunc(selldate) = '22-NOV-1998';

Works just fine.

Andrew Semprebon wrote:

> Use to_date to make sure you are getting the correct century/time.
> When you specify "22-NOV-98", it will assume some century (we hope
> 1900s) and midnight. The following should take care of these
> problems:
>
> >
Received on Wed Nov 11 1998 - 00:00:00 CST