Greeting People,,

I'm trying to retrieve records from table by knowing the date in column contains date and time.

let me explain my self clearly with this example:

suppose i have table called t1 which contains only two column name, date respectively

the data stored in column date like this "8/3/2010 12:34:20 PM"

i want to retrieve this record by this query for example:

Select * from t1 where date="8/3/2010" // notes i don't put the time.

this query give me nothing !

SO now my question is how can i retrieve date by knowing only date without the time !