SQL 插入更新的 时间 差

update dbo.LeaveDocuments  set  DataDay =  convert(float , (
SELECT DATEDIFF(day, CreateTime , getdate()) AS no_of_days
FROM dbo.LeaveDocuments where  LeaveID = 'ZYQJ2013030002'
)) where  TaskID =188
原文地址:https://www.cnblogs.com/dullbaby/p/2953003.html