Date Timezone MSSQL

  1. Home
  2. MSSQL
  3. Date Timezone
  4. Dateparts and Abbreviations
Datepart      Abbreviation
year          yy, yyyy
quarter       qq, q
month         mm, m
dayofyear     dy, y
day           dd, d
week          wk, ww
weekday       dw
hour          hh
minute        mi, n
second        ss, s
millisecond   ms