| 10.3.DATEADD |
| 10.3.1. | DATEADD adds or subtract a number of days, months, or years from a specific date. |
| 10.3.2. | DATEADD adds a time interval to a date in order to arrive at the new date: DATEADD(datepart,number,date) |
| 10.3.3. | Determine the date 90 days after April 29, 1988 |
| 10.3.4. | select DATEADD(day, 1, '2002-09-30 11:35:00') |
| 10.3.5. | select DATEADD(month, 1, '2002-09-30 11:35:00') |
| 10.3.6. | select DATEADD(year, 1, '2002-09-30 11:35:00') |
| 10.3.7. | select DATEADD(hour, 1, '2002-09-30 11:35:00') |
| 10.3.8. | select DATEADD(minute, 1, '2002-09-30 11:35:00') |
| 10.3.9. | select DATEADD(second, 1, '2002-09-30 11:35:00') |
|
| 10.3.10. | select DATEADD(quarter, 1, '2002-09-30 11:35:00') |
| 10.3.11. | select DATEADD(week, 1, '2002-09-30 11:35:00') |
| 10.3.12. | select DATEADD(month, -1, '2002-09-30 11:35:00') (Minus) |
| 10.3.13. | select DATEADD(year, 1.5, '2002-09-30 11:35:00') |
| 10.3.14. | SELECT DATEADD(day, 14, GETDATE()) |
| 10.3.15. | Calculating the First Day of the Month |
| 10.3.16. | Finding the Last Day of the Month |