天数
DATEDIFF(dd, date1, date2)
年
DATEDIFF(m, date1, date2)
其他的参数对照如下
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
DATEDIFF(dd, date1, date2)
年
DATEDIFF(m, date1, date2)
其他的参数对照如下
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
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 SELECT DATEDIFF(d, 'time1', getdate())
SELECT DATEDIFF(m, 'time1', getdate())
的月份不是要求的月份。如datediff(m, '20030227', '20030302')应该不足一个月 但结果却是1
如何让它的值为0呢