Cannot search for a date in a DateTime column having TimeStamp
I have a DateTime datatype column, with records showing as:
2002-10-05 10:29:29.001
2002-10-05 10:29:30.245
2002-10-10 10:29:31.324
2002-10-07 10:29:32.454
2002-10-07 10:29:33.343
2002-10-07 10:29:34.565
2002-10-05 10:29:35.353
2002-10-05 10:29:36.578
2002-10-05 10:29:37.943
2002-10-01 10:29:38.115
2002-10-01 10:29:39.564
and I want to search for records with date, say 2002-10-07, and it not work if I search with '10/07/2002' but if I give, say '10/07/200 10:29:34.565' it will only pull up that one record. I want to pull all 3 records having date of 10/07/2002.
EXAMPLE 1:
SELECT email_address AS Email, Sent
FROM email_address
WHERE Send = '#10/07/2002#'
shows (0 row(s) affected)