mysql 中文星期几

DELIMITER //

CREATE FUNCTION ChineseWeekday(weekday INT) RETURNS VARCHAR(10)
BEGIN
    DECLARE chinese_weekday VARCHAR(10);
    CASE weekday
        WHEN 1 THEN SET chinese_weekday = '星期日';
        WHEN 2 THEN SET chinese_weekday = '星期一';
        WHEN 3 THEN SET chinese_weekday = '星期二';
        WHEN 4 THEN SET chinese_weekday = '星期三';
        WHEN 5 THEN SET chinese_weekday = '星期四';
        WHEN 6 THEN SET chinese_weekday = '星期五';
        WHEN 7 THEN SET chinese_weekday = '星期六';
        ELSE SET chinese_weekday = '';
    END CASE;
    RETURN chinese_weekday;
END //

DELIMITER ;

SELECT ChineseWeekday(DAYOFWEEK('2023-10-01')) AS chinese_weekday;

+--------------+
| chinese_weekday |
+--------------+
| 星期日        |
+--------------+