16>
17> SELECT DATENAME(mm,DATEADD(mm,2,GETDATE()))
18> GO
------------------------------
December
(1 rows affected)
Year - yy, yyyy
Month - mm, m
Week - wk, ww
Day - dd, d
Hour - hh
Minute - mi, n
quarter - qq
day of year - dy
seconds - ss
milliseconds - ms