to_date function

dear all

I am having difficulty selecting records based on dates. Can anyone help?

I tried using
select * from tableA where created_date = to_date('15/12/01', 'dd/mm/yy');

though i have records in the database. i do not get any results executing the above mentioned SQL code. anyone can lend a hand on this????? thanks Received on Mon Dec 17 2001 - 23:46:09 CST