Mega Code Archive

 

Categories / MSSQL Tutorial / Date Functions

 

Values for the datepart parameter

This  function returns an integer value  for the part of a date specified in the date part selection. The syntax for DATEPART is: DATEPART ( datepart , date ) The second parameter, date, designates the date for which the integer value is calculated. datepart (Full Name)       Abbreviation             Values year                       Yy                       1753-9999 quarter                    Qq                       1-4 month                      Mm                       1-12 dayofyear                  Dy                       1-366 day                        Dd                       1-31 week                       Wk                       1-53 weekday                    Dw                       1-7 (Sunday-Saturday) hour                       Hh                       0-23 minute                     Mi                       0-59 second                     Ss                       0-59 millisecond                Ms                       0-999