Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Difference between SYSDATE and TO_DATE

Re: Difference between SYSDATE and TO_DATE

From: Tom <tomNOSPAM_at_teameazyriders.com>
Date: Thu, 30 Oct 2003 13:24:36 -0000
Message-Id: <1067520374.3388.0@despina.uk.clara.net>

> Tom,
>
>
>
> You need to be careful when working with date and remember that the date
> functions are available so use them when needed. Also when using the
> date range, allways go from older-date to newer-date not the other way
> around like you had, so try this instead:
>
>
>
> SELECT Count(*)
>
> FROM EVENTSTREAM
>
> WHERE TYPE = 11
>
> AND (TS BETWEEN to_char(sysdate -1, 'DD-MON-YY') AND
>
> to_char(sysdate, 'DD-MON-YY'));

Thanks all -

seems i should avoid using sysdate then and focus on to_date.

thanks

Tom Received on Thu Oct 30 2003 - 07:24:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US