select CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, GetDate())))
select FLOOR(CONVERT(FLOAT, GetDate())), CONVERT(FLOAT, GetDate())
select CONVERT(DATETIME, 41316)
转载于:https://blog.51cto.com/cnming/1133558
select CONVERT(DATETIME, FLOOR(CONVERT(FLOAT, GetDate())))
select FLOOR(CONVERT(FLOAT, GetDate())), CONVERT(FLOAT, GetDate())
select CONVERT(DATETIME, 41316)
转载于:https://blog.51cto.com/cnming/1133558