Re: sysdate

You don't need to join the dual table, and if you can, don't apply function on column because if the column is indexed, Oracle will not use the index, so :
select abc
from xyz
where activitydate>=trunc(sysdate)
and activitydate < (trunc(sysdate+1))

Jerome. (jt_at_ystel.fr)

Arjan van Bentem <avbentem_at_DONT-YOU-DAREdds.nl> a écrit dans le message : 7dtbpt$bp6$1_at_weber.a2000.nl...
> 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