How can I search a datetime field with MSSQL 2008 / ASP.NET VB?

Here is a sample record:

9/29/1971 12:15 AM (This is a DateTime Field)

when I use the following:

select * from my table where MyDateTime LIKE '9/29/1971'

I get nothing?

Also while I am at it how would I search for time as well?

select * from my table where MyDateTime LIKE '12:15 AM'

Thanks!