** Need Oracle Date Function to return records with seconds too

Hello,
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?

Thanks!
dunkin1969Asked:
Who is Participating?
 
awking00Connect With a Mentor Commented:
WHERE TRUNC(CALL_DATE) = TO_DATE('10/11/2010','mm/dd/yyyy');
0
 
dunkin1969Author Commented:
THANKS !!!!!
0
 
awking00Commented:
You're most welcome.
0
 
sweetfa2Commented:
where to_char(call_date,'mm/dd/yyyy') = '10/11/2010'
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.