Query on a Date and Time in Oracle not returning a value
Posted on 2014-04-25
I know this is simple but it's Friday and I am brain fried
I have this simple Where clause in my query
WHERE to_date(s.login_date) >= to_date('04/25/2014 10:14:14 AM', 'mm/dd/yyyy hh:mi:ss AM')
The record I expcet back has a login date of 04/25/2014 01:15:25 PM
I am not getting the query to return my record. If I set the query to use 4/24 then I get it but I also get other information I don't want. Why does it not understand the PM value is greater then the AM value?