I am using Oracle DB. I have one table which has one column with data type as timestamp. e.g data for this column is "26-FEB-08 126.96.36.1992000000 AM".
Now I want to fetch all records created on the particular date. So I am writing query like "Select * from TABLE_XYZ where date like '26-FEB-08'", but its not fetching the records.
Solution to this problem is fetch data between two dates like "Select * from TABLE_XYZ where date between '26-FEB-08' and '27-FEB-08'".
Is there any functions that I can use, which will get me the records of the particular date, by which I can get results without using 'between'. Problem with second approach, I need to take care of invalid dates.