Where clause for date/time stamp
632909Aug 6 2009 — edited Aug 6 2009Hi Guys,
I have a 'Timestamp' column in my table, which has following format:
Start_Timestamp
------------------------
M/D/YYYY HH:MM/SS AM OR PM
8/6/2009 8:53:11 AM
Now, I want to get all the rows that have start_timestamp more than 8/3/2009. When I issue the following condition at where clause, it only gives me the current day and not all the days after August 3rd:
"Where start_timestamp > TO_DATE('08/03/2009 08:59:01', 'MM/DD/YYYY HH24:MI:SS')"
What should I do here to eliminate this issue? Initially it looked like a very simple query, but I am sure there's something wrong in the above. I even tried to use the 'Trunc' function, but with the same results.
Please help. Really appreciate it.