Query date column in Oracle
Posted on 2013-05-16
I need to query an oracle table by date and am not having any luck. I want to search by date, date only. I have a table with a date column and in the date column is the following data:
08/27/2012 8:16:00 AM
I want to query by date and enter '8/27/2012' or '08/27/2012' and yield the record. However, the record is not found unless I enter the time as well, or use a between that includes time. Any help you can provide is much appreciated.
select from table where date .....'8/27/2012'