Date Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Date Functions
  4. DATEPART returns part of a date as an integer value
The syntax  for DATEPART is: DATEPART(part_of_the_date_to_return, the_date)
19>
20> SELECT DATEPART(dw,GETDATE())
21> GO
-----------
          1
(1 rows affected)