|
| |
| 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(month, '9-8-1989', '10-17-1991') | | | | 11. | DATEDIFF(day, '9-8-1989', '10-17-1991') | | | | 12. | Difference in weeks between 7-2-1996 and 8-4-1997 | | | | 13. | DATEDIFF(ss, @MyBirthDate, GETDATE()) | | | | 14. | select DATEDIFF(hour, '06:46:45', '11:35:00') | | | | 15. | select DATEDIFF(minute, '06:46:45', '11:35:00') | | | | 16. | Difference between the current time and UTC | | | | 17. | DATEDIFF: date difference | | | | 18. | Combine DateADD and DateDIFF to get the last date of a month | | | | 19. | Passing a column name to the DATEDIFF() value argument | | |
|