将日期截断为仅小时/分钟
我如何在SQL Server 2008中截断日期,如下所示:我有2012-01-02 12:04:11.443,我只想选择2012-01-02 12:00:00.000和2012-01-02
12:04:00.000(小时和分钟级别)
解决方案:
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)
页:
[1]