date column select question

From: Ralph Snart <snart_at_nospam.com>
Date: Thu, 08 Aug 2002 23:13:42 GMT
Message-Id: <slrnal5uuj.1iac.snart@cluttered.com>

ok this is really dumb, and i would think it's also a faq, although all the faq references i have seen only deal with inserts and not selects.

i've been mainly using mysql lately so my oracle knowledge has totally dried up.

how do i select a specific date from a date column?

select * from table where date='05-AUG-02'

returns nothing even though there are rows with that date. the only way i can get it to work is to do this horrible construction:

select * from table where
date BETWEEN TO_DATE('08/05/2002 00:00:00', 'MM/DD/YYYY HH24:MI:SS') AND TO_DATE('08/06/2002 00:00:00', 'MM/DD/YYYY HH24:MI:SS') there's got to be a simpler way...

-rs- Received on Thu Aug 08 2002 - 18:13:42 CDT