SELECT DATEPART(weekday, CAST('20051004' AS DATETIME) + @@DATEFIRST); : DATEFIRST « Date Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Date Functions
  3. DATEFIRST
6> SELECT DATEPART(weekday, CAST('20051004' AS DATETIME) + @@DATEFIRST);
7> GO

-----------
          3

-----------
          3
1>








10.5.DATEFIRST
10.5.1.To change the first day value, you can use the SET DATEFIRST command.
10.5.2.Using SQL Server's First Day of the Week Setting
10.5.3.SELECT DATEPART(weekday, CAST('20051004' AS DATETIME) + @@DATEFIRST);