Re: sysdate & date columns

Try This....

alter session set NLS_DATE_FORMAT='MM-DD-YYYY'; --no time info select * from table1 where date1 = sysdate;

This must work!

Larry Pettit wrote:

> This doesn't work.
>
> select * from table1 where date1 = sysdate
> Is there a way to compare a date column with sysdate other than
> converting both using to_char()?
>
> I think the time part of the date is causing this not to work, any
> suggestions?
>
> Thanks
Received on Wed Jan 19 2000 - 19:55:43 CST