To compare date part only in sql
WHERE CONVERT(VARCHAR, date1, 101) = CONVERT(VARCHAR, date2, 101)
http://stackoverflow.com/questions/1427469/compare-dates-in-t-sql-ignoring-the-time-part
No comments:
Post a Comment