Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: sysdate & date columns
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.134$j4.7687_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:35:33 CST