Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: sysdate
Why not ?
where mytable.start_date between sysdate and sysdate + 7
Regards,
Marc Mazerolle
K.S. wrote:
> Anyone know if you could use sysdate in a where clause to show an
> activity occuring that day? when trying to constrict a search
>
> egs..
>
> select abc
> from xyz, dual
> where activitydate = sysdate
Received on Wed Mar 31 1999 - 00:00:00 CST