DATEDIFF(month, '9-8-1989', '10-17-1991')
1> -- DATEDIFF() Function
2>
3> --There are four elements in this equation: the start date, the interval (date unit),
4> -- the difference value, and the end date.
5>
6> -- What the difference is between the dates 9-8-1989 and 10-17-1991 in months:
7>
8> SELECT DATEDIFF(month, '9-8-1989', '10-17-1991')
9> GO
-----------
25
(1 rows affected)
1>
2>
Related examples in the same category
| 1. | DATEDIFF: return the difference between two dates | | |
| 2. | select DATEDIFF(second, '06:46:45', '11:35:00') | | |
| 3. | select DATEDIFF(quarter, '2001-12-01', '2002-09-30') | | |
| 4. | Find the number of days between 24th March 2001 and 24th March 1964 | | |
| 5. | DATEDIFF(yyyy, "24 March 2001","24 March 1964") | | |
| 6. | DATEDIFF(mi, "24 March 2001","24 March 1964") | | |
| 7. | DATEDIFF(wk, "24 March 2001","24 March 1964") | | |
| 8. | DATEDIFF(m, "24 March 2001","24 March 1964") | | |
| 9. | DATEDIFF(d, @thisdate, @nextmonth) 'Days between' | | |
| 10. | DATEDIFF(day, '9-8-1989', '10-17-1991') | | |
| 11. | Difference in weeks between 7-2-1996 and 8-4-1997 | | |
| 12. | DATEDIFF(ss, @MyBirthDate, GETDATE()) | | |
| 13. | select DATEDIFF(hour, '06:46:45', '11:35:00') | | |
| 14. | select DATEDIFF(minute, '06:46:45', '11:35:00') | | |
| 15. | Difference between the current time and UTC | | |
| 16. | DATEDIFF: date difference | | |
| 17. | Combine DateADD and DateDIFF to get the last date of a month | | |
| 18. | Passing a column name to the DATEDIFF() value argument | | |