|
| |
| 10. 4. 3. select DATEDIFF(day, '2001-12-01', '2002-09-30') |
|
|
|
2>
3> select DATEDIFF(day, '2001-12-01', '2002-09-30')
4> GO
-----------
303
(1 rows affected)
|
|
| 10. 4. DATEDIFF | | 10. 4. 1. | Finding the Difference Between Two Dates | | | | 10. 4. 2. | DATEDIFF returns the difference between two dates as specified by datepart: DATEDIFF(datepart,date1,date2) | | | | 10. 4. 3. | select DATEDIFF(day, '2001-12-01', '2002-09-30') | | | | 10. 4. 4. | select DATEDIFF(month, '2001-12-01', '2002-09-30') | | | | 10. 4. 5. | select DATEDIFF(year, '2001-12-01', '2002-09-30') | | | | 10. 4. 6. | select DATEDIFF(hour, '06:46:45', '11:35:00') | | | | 10. 4. 7. | select DATEDIFF(minute, '06:46:45', '11:35:00') | | | | 10. 4. 8. | select DATEDIFF(second, '06:46:45', '11:35:00') | | | | 10. 4. 9. | select DATEDIFF(quarter, '2001-12-01', '2002-09-30') | | | | 10. 4. 10. | select DATEDIFF(week, '2001-12-01', '2002-09-30') | | | | 10. 4. 11. | select DATEDIFF(day, '2002-09-30', '2001-12-01') | | | | 10. 4. 12. | SELECT DATEDIFF(yy, 'Jan 1, 1998', 'Dec 31, 1998') | | | | 10. 4. 13. | SELECT DATEDIFF(yy, 'Dec 31, 1998', 'Jan 1, 1999') | | | | 10. 4. 14. | Find difference in months between now and EndDate | | | | 10. 4. 15. | A SELECT statement that computes the age of a Billing with DATEDIFF | | | | 10. 4. 16. | Days between two dates | | |
|