SELECT DATEADD(dd, DATEDIFF(dd, 0, postDate), 0)
FROM table
WHERE (postDate >= @StartDate) AND (postDate < DATEADD(day, 1, @EndDate))
GROUP BY DATEADD(dd, DATEDIFF(dd, 0, postDate), 0)
ORDER BY DATEADD(dd, DATEDIFF(dd, 0, postDate), 0)
sql group by datetime on day
求人不如求己。吃得苦中苦,方为人上人。 失意时莫灰心,得意时莫忘形。