Re: sysdate

From: <dean.reynolds_at_home.net>
Date: 1999/03/31
Message-ID: <37024809.4875090@news>#1/1

That's the one to use-- the one with the 'trunc'.

-Dean

On Wed, 31 Mar 1999 16:34:36 +0200, "Arjan van Bentem" <avbentem_at_DONT-YOU-DAREdds.nl> wrote:

>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