DATENAME returns the part of the date in a literal form
17> 18> SELECT DATENAME(mm,GETDATE()) 19> GO ------------------------------ October (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