SQL Distinct Dates

If you wish to select distinct Dates from a table, as opposed to distinct DateTimes, simply use the following:

select distinct(cast(datediff(day, 0, KickoffDate) as datetime)) AS
GameDate
from tblFixtures