select * from APP_SWIFT_INFO where CREATED_DATE = to_date('04/15/2011','mm/dd/yyyy');
I want to get data by date field, could you tell me please how to get the data by date field and what is wrong in the above query.
In my database data in the date field like this
4/19/2011 2:06:18 PM
Here I want to send only the date and read the corresponding record.