|
| |
| 10. 3. 2. DATEADD adds a time interval to a date in order to arrive at the new date: DATEADD(datepart,number,date) |
|
|
|
Parts of the date.
Date Part Description Value Range
YY Year 1753 to 9999
QQ Quarter 1 to 4
MM Month 1 to 12
DY Day of year 1 to 366
DD Day of month 1 to 31
WK Week of year 1 to 53
DW Weekday 1 to 7 or Sun. to Sat.
HH Hour 0 to 23 (military time)
MI Minute 0 to 59
SS Second 0 to 59
MS Millisecond 0 to 999
34> SELECT DATEADD(DY,30,"10/01/97")
35> GO
-----------------------
1997-10-31 00:00:00.000
(1 rows affected)
1>
|
|
| 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 | | |
|