Re: sysdate

Marc Mazerolle wrote
> Why trunc sysdate at all in a between or in a <= condition ?

If you don't use trunc(..), like

    select abc
    from xyz
    where activitydate>=sysdate
    and activitydate < (sysdate+1)

then at 21:12 you'd only select activity dates between today, 9:12 p.m. and tomorrow, 9:12 p.m. I doubt that is what anyone would ever need....

Arjan. Received on Wed Mar 31 1999 - 00:00:00 CST