date/time field and its index
From: Mark Citron <mcitron_at_hsc.usc.edu>
Date: 16 Sep 1994 12:31:17 -0700
Message-ID: <35crq5$pm1_at_hsc.usc.edu>
Date: 16 Sep 1994 12:31:17 -0700
Message-ID: <35crq5$pm1_at_hsc.usc.edu>
I have a field which I am storing the date and time.
How do I select all rows with today's date (ie disregard time)?
If I do a to_date to strip out the time I loose the use of the index on the field.
Any suggestions would be welcome.
Mark Citron
Childrens Hospital Los Angeles
-- Mark Citron mark_at_neurosci.usc.eduReceived on Fri Sep 16 1994 - 21:31:17 CEST