Re: sysdate & date columns

<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 - 05:18:24 CST