select datediff(s,'2012-12-11 8:00:00','2012-12-11 08:31:47')
结果是1907 (秒)
语法
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
microsecond mcs
nanosecond ns
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024