Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Difference between SYSDATE and TO_DATE
> 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