Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sysdate
Marc Mazerolle wrote
> where mytable.start_date between sysdate and sysdate + 7
Ehhh, why search for a start date from now, until 7x24 hours from now?
> > select abc
> > from xyz, dual
> > where activitydate = sysdate
where trunc(activitydate) = trunc(sysdate)
Arjan. Received on Wed Mar 31 1999 - 00:00:00 CST