Datepart Abbreviationyear yy, yyyyquarter qq, qmonth mm, mdayofyear dy, yday dd, dweek wk, wwweekday dwhour hhminute mi, nsecond ss, smillisecond ms