-- Independent weekday (logical DATEFIRST = 7)
SELECT DATEPART(weekday, GETDATE() + @@DATEFIRST);
-- Independent weekday (logical DATEFIRST = 1)
SELECT DATEPART(weekday, GETDATE() + @@DATEFIRST - 1);
转载于:https://www.cnblogs.com/andy_tigger/archive/2011/12/28/2304555.html