sql - 将日期截断为仅小时/分钟

Question

如何在 sql server 2008 中截断日期，如下所示:

我有 2012-01-02 12:04:11.443，我只想选择 2012-01-02 12:00:00.000 和 2012 -01-02 12:04:00.000(小时和分钟级别)

Answer 1

declare @D as datetime = '2012-01-02T12:04:11.443'

select dateadd(hour, datediff(hour, 0, @D), 0)
select dateadd(minute, datediff(minute, 0, @D), 0)