Sqlserver 中,我想计算两个日期之差,可以应该如下语法进行:
SELECT DeadLineDateTime,SignDateTime , DateDiff(dd,DeadLineDateTime, SignDateTime) as day FROM AFS_FLOW where DateDiff(dd,DeadLineDateTime, SignDateTime) > 15
其中:DateDiff(dd,DeadLineDateTime, SignDateTime) ,DeadLineDateTime为开始时间,SignDateTime为开始时间,此函数返回值为天数。
SELECT DeadLineDateTime,SignDateTime , DateDiff(dd,DeadLineDateTime, SignDateTime) as day FROM AFS_FLOW where DateDiff(dd,DeadLineDateTime, SignDateTime) > 15
其中:DateDiff(dd,DeadLineDateTime, SignDateTime) ,DeadLineDateTime为开始时间,SignDateTime为开始时间,此函数返回值为天数。