sql select # of matches for each date (no time) in table code example
Example 1: how to select only a certain date sql
SELECT *
FROM sales
WHERE salesDate BETWEEN '11/11/2010 00:00:00.00' AND '11/11/2010 23:59:59.999'
Example 2: how to update date value in sql
UPDATE TABLE
SET EndDate = CAST('2009-05-25' AS DATETIME)
WHERE Id = 1