Could you elaborate on your comment about the timepart?

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 19 Jul 1999 10:35:13 GMT
Message-ID: <01bed1db$7c31e400$2c289a0a@apollo>

Hi Sybrand

I didnt understand this bit, but it sounds interesting:
> General note: Make sure there is either no time in your date field, or in
> all your where clauses take into account there is a date in your field.
This
> results in
> between ... and to_date(date_variable2) + 1 - 1/3600

Well actually the four above lines dont make sense to me at all. Could you elaborate on them?
How are indexes on datefields organized? Values are almost unique, as in very few are equal to the last fraction. Indexes ofcourse take into account the hole date/time part and not only the date?

Thanks
Peter Received on Mon Jul 19 1999 - 05:35:13 CDT