土豆烧牛肉

导航

 

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)

posted on 2016-07-27 15:42  土豆烧牛肉  阅读(241)  评论(0编辑  收藏  举报