date/time field and its index
From: Barry Roomberg <barry.roomberg_at_compudata.com>
Date: Sat, 17 Sep 94 09:56:00 -0500
Message-ID: <12a.4927.905_at_compudata.com>
Date: Sat, 17 Sep 94 09:56:00 -0500
Message-ID: <12a.4927.905_at_compudata.com>
-> 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.
Try "date_field between trunc(sysdate) and trunc(sysdate+1)" Received on Sat Sep 17 1994 - 16:56:00 CEST