MSSQL 日期相关操作

 

1.两个日期的天数差

 

SELECT DATEDIFF(day, '2005-12-30 23:59:59.000' , '2006-01-01 00:00:00.0000000');

其它参数：

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