SQL SERVER DATEDIFF - T-SQL version of days_between and months_between.
August 20th, 2007 | by programming |Returns number of days, months, weeks, hours, minutes etc. between two dates.
Syntax: DATEDIFF(datepart_code, startdate, enddate);
Date Part | Code
——————————–
Year | yy, yyyy
Quarter | qq, q
Month | mm, m
Day of year | dy, y
Day | dd, d
Week | wk, ww
Hour | hh
Minute | mi, n
Second | ss, s
Millisecond | ms