Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

DATEADD adds a time interval to a date in order to arrive at the new 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>