select DATEADD(Day, DATEDIFF(Day,0,GETDATE()), 0),DATEDIFF(Day,0,GETDATE()),GETDATE()
结果:
(无列名) (无列名) (无列名)
2015-01-30 00:00:00.000 42032 2015-01-30 20:04:57.050
select DATEADD(Day, DATEDIFF(Day,0,GETDATE()), 0),DATEDIFF(Day,0,GETDATE()),GETDATE()
结果:
(无列名) (无列名) (无列名)
2015-01-30 00:00:00.000 42032 2015-01-30 20:04:57.050
转载于:https://www.cnblogs.com/Unrmk-LingXing/p/4263098.html