How to search data by date in where clause in PL/SQL
Posted on 2011-04-19
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.