** Need Oracle Date Function to return records with seconds too
Posted on 2010-11-23
I have a table column in date/time format.
How can I query for all records with CALL_DATE = 10/11/2010?
If I use WHERE CALL_DATE = TO_DATE('10/11/2010', 'mm/dd/yyyy')
Then I only get records with CALL_DATE = 10/11/2010 00:00:00
I need to get all the other times of the day.
Is there a way to do this using the above syntax, or do I have to use BETWEEN?