What if date_column has a time node of 1PM, and SYSDATE has 2PM? This will
statement will fail....
Igor V. Podolsky <igoryok_at_soft-review.kiev.ua> wrote in message
news:AASxkXuS806_at_soft-review.kiev.ua...
> <klingfam_at_epix.net> wrote in message news:38867BD5.C9D237AF_at_epix.net...
>
> > Yes,
> > try trunc(date_column) = trunc(sysdate)
> >
> > I do this all the time it takes the time portion off the date and
> > compares just the date .
>
> It works, but indexes couldn't be used. I'd prefer something like
>
> date_column >= sysdate and date_column < sysdate + 1
>
> --
> Is There A God Or Any Kind Of Justice Under The Sky... (Queen'91)
>
> Igor V. Podolsky (igoryok_at_soft-review.kiev.ua)
>
>
Received on Thu Jan 20 2000 - 18:14:04 CST
