Re: sysdate and date columns

From: Michel Cadot <micadot_at_netcourrier.com>
Date: Thu, 20 Jan 2000 13:34:05 +0100
Message-ID: <866vc4$1b2e$1@news6.isdnet.net>

Maybe:
select * from table1 where trunc(date1) = trunc(sysdate)

--
Have a nice day
Michel

Larry Pettit <larry.pettit_at_ps.net> a écrit dans le message : yTrh4.133$j4.7298_at_news.uswest.net...
>
> 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 Thu Jan 20 2000 - 06:34:05 CST