?
Solved

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

Posted on 2010-11-23
4
Medium Priority
?
442 Views
Last Modified: 2013-12-07
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!
0
Comment
Question by:dunkin1969
  • 2
4 Comments
 
LVL 32

Accepted Solution

by:
awking00 earned 2000 total points
ID: 34198643
WHERE TRUNC(CALL_DATE) = TO_DATE('10/11/2010','mm/dd/yyyy');
0
 

Author Comment

by:dunkin1969
ID: 34198657
THANKS !!!!!
0
 
LVL 32

Expert Comment

by:awking00
ID: 34198672
You're most welcome.
0
 
LVL 17

Expert Comment

by:sweetfa2
ID: 34198682
where to_char(call_date,'mm/dd/yyyy') = '10/11/2010'
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question