select datepart(dw,'2009-1-7') select datename(dw,'2009-1-7') 转载于:https://www.cnblogs.com/yuanweisen/archive/2009/01/07/1371081.html