How do I search DateTime Data in MS SQL 2005?
Posted on 2007-12-03
I am trying to create search page in ASP classic.
How do I create a query that will select similar date?
For Example, when I use this query " Select * from Board where RegisterDate ='2007-11-28' " it gave me a blank result because I didn't input the time.
So I used "Like" query, and it still gives me a blank result.
Select * from Board where RegisterDate Like '%2007-11-28%' "
How do I select the date without inputing time?