date problem

Feb 26 2008 5:57 AM
hi.........
its not a big problem, but i'm sliping something.
i have smalldatetime field that store date & time. but when i compare date with only date format, query doen't show any result.
example:

in table the date field store is: 11/28/2007 00:25:00
now, i ' m using
select * from emp where cDate =CONVERT(VARCHAR(10),'11/28/2007',111)
it doesn't return any answer.

but if i use
 select * from emp where cDate >=CONVERT(VARCHAR(10),'11/28/2007',111)
it will show the result.
please help us.

thanks

Answers (2)