select DATEDIFF(day, time1 , time2) 对应示例语句如下
select DATEDIFF(day, '2010-07-23 0:41:18', '2010-07-23 23:41:18')
time1 > time2 为负数;
select DATEDIFF(day, time1 , time2) 对应示例语句如下
select DATEDIFF(day, '2010-07-23 0:41:18', '2010-07-23 23:41:18')
time1 > time2 为负数;