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)
使用 Dateadd(dd/mm/yy, datediff(...), 0) 得出的是Date属性的column,比直接convert left(xx,10)要更简便易用
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)
使用 Dateadd(dd/mm/yy, datediff(...), 0) 得出的是Date属性的column,比直接convert left(xx,10)要更简便易用