DATEADD adds a time interval to a date in order to arrive at the new date: DATEADD(datepart,number,date) : DATEADD « Date Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Date Functions
  3. DATEADD
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