Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Difference between SYSDATE and TO_DATE
no need to avoid sysdate -- just be aware of what it does
"Tom" <tomNOSPAM_at_teameazyriders.com> wrote in message
news:1067520374.3388.0_at_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 - 09:54:46 CST