Date Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Date Functions
  4. SELECT DATEPART(weekday, CAST(20051004 AS DATETIME) + @@DATEFIRST)
6>  SELECT DATEPART(weekday, CAST('20051004' AS DATETIME) + @@DATEFIRST);
7> GO
-----------
          3
-----------
          3
1>