Re: sysdate & date columns

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 20 Jan 2000 19:29:17 +0800
Message-ID: <3886F18D.3492@yahoo.com>

Igor V. Podolsky wrote:
>
> <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)

You'll need a trunc around your sysdate's to do this... --

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Thu Jan 20 2000 - 05:29:17 CST