二、英文
CREATE FUNCTION getWeek
(
@ADay DATETIME
) RETURNS VARCHAR(20)
BEGIN
RETURN CASE DATEPART(dw, @ADay)
WHEN 1 THEN 'Sunday'
WHEN 2 THEN 'Monday'
WHEN 3 THEN 'Tuesday'
WHEN 4 THEN 'Wednesday'
WHEN 5 THEN 'Thursday'
WHEN 6 THEN 'Friday'
WHEN 7 THEN 'Saturday'
END
END
一、中文 DATENAME(dw, GetDate())二、英文CREATE FUNCTION getWeek(@ADay DATETIME) RETURNS VARCHAR(20) BEGIN RETURN CASE DATEPART(dw, @ADay) WHEN 1 THEN Sunday WHEN 2 T