Oracle datetime query question
Posted on 2009-04-06
A junior question: I have some records with the saved_date filed: 03/04/2009, but when I run below query, no result displayed:
select * from table_name where saved_date = to_date('03/04/2009','mm/dd/yyyy')
When I changed to:
select * from table_name where saved_date >= to_date('03/04/2009','mm/dd/yyyy')
Then the three records of that day is shown. Could anyone let me know why the second ">=" query only returns the record of particular date instead of all the records after that date and how I could get the date query for a particular date?