Select records based on Timestamp
Posted on 2006-04-14
This is rather simple question, i might doing something wrong. I have a table with one of the column as timestamp.
The data stored is in format MM/DD/YYYY 24HH:MI:SS.
I want to select the records greater or equal to a certain date.
When i try select * from <tablename> where to_char(timestamp,'MM\DD\YYYY') >= '04/12/2006 5:41:43 PM'
it is returning all the records even before the date given in where condition.