I have a query:
SELECT * FROM
test
WHERE created_dt >='14-MAY-10'
AND created_dt<='14-MAY-10'
returns no row...
Although there is data in the table for that particular date, the data is with the timestamp. "14-MAY-10 04:05:22"
if i query : select * from test; i am able to get the data i.e one row for 14 th may 2010.
please suggest to modify the main query in order to retrieve the result.