獲取某天是星期幾

select datename(weekday,'2006-02-28')
----
星期二

Other:
select datename(week,'2006-02-28')
----
9

原文地址:https://www.cnblogs.com/tohen/p/345810.html