select DATEDIFF(day, time1, getdate()) from table//与系统日期相比 select DATEDIFF(day, time1, time2) from table
select DATEDIFF(Hour, time1, getdate()) from table//与系统日期相比 select DATEDIFF(Hour, time1, time2) from table
DATEDIFF(datepart , startdate , enddate) 下面是参数datepart,年月日周时分秒都可以用这个函数 year yy, yyyy quarter qq, q Month mm, m dayofyear dy, y Day dd, d Week wk, ww Hour hh minute mi, n second ss, s millisecond ms
若要求 time1-time2的值则将 time1和time2位置对调一下
select DATEDIFF(day, time1, time2) from table
select DATEDIFF(Hour, time1, time2) from table
下面是参数datepart,年月日周时分秒都可以用这个函数
year yy, yyyy
quarter qq, q
Month mm, m
dayofyear dy, y
Day dd, d
Week wk, ww
Hour hh
minute mi, n
second ss, s
millisecond ms