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'));

Linh

--
Posted via http://dbforums.com