search record from table at given date

you pass date as varchar type and mm/dd/yyyy format

select * from emp where (createddate>'11/15/2008' and

createddate<DATEADD(day,1, '11/15/2008'))