1 ALTER FUNCTION [dbo].[英文星期] 2 ( 3 @ADay DATETIME 4 ) RETURNS VARCHAR(20) 5 BEGIN 6 DECLARE @Week VARCHAR(20) 7 SELECT @Week = CASE DATEDIFF(dd, DATEADD(wk, DATEDIFF(wk,0, @ADay), 0), @ADay) + 1 8 WHEN 0 THEN 'Sunday' 9 WHEN 1 THEN 'Monday' 10 WHEN 2 THEN 'Tuesday' 11 WHEN 3 THEN 'Wednesday' 12 WHEN 4 THEN 'Thursday' 13 WHEN 5 THEN 'Friday' 14 WHEN 6 THEN 'Saturday' 15 END 16 RETURN @Week 17 END