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>