在标准sql中获取从星期一开始的周日期

SELECT 
    CASE 
        WHEN DAYOFWEEK(date_column) = 1 THEN DATE_SUB(date_column, INTERVAL 6 DAY)
        WHEN DAYOFWEEK(date_column) = 2 THEN date_column
        WHEN DAYOFWEEK(date_column) = 3 THEN DATE_SUB(date_column, INTERVAL 1 DAY)
        WHEN DAYOFWEEK(date_column) = 4 THEN DATE_SUB(date_column, INTERVAL 2 DAY)
        WHEN DAYOFWEEK(date_column) = 5 THEN DATE_SUB(date_column, INTERVAL 3 DAY)
        WHEN DAYOFWEEK(date_column) = 6 THEN DATE_SUB(date_column, INTERVAL 4 DAY)
        WHEN DAYOFWEEK(date_column) = 7 THEN DATE_SUB(date_column, INTERVAL 5 DAY)
    END AS start_of_week,
    DATE_ADD(
        CASE 
            WHEN DAYOFWEEK(date_column) = 1 THEN DATE_SUB(date_column, INTERVAL 6 DAY)
            WHEN DAYOFWEEK(date_column) = 2 THEN date_column
            WHEN DAYOFWEEK(date_column) = 3 THEN DATE_SUB(date_column, INTERVAL 1 DAY)
            WHEN DAYOFWEEK(date_column) = 4 THEN DATE_SUB(date_column, INTERVAL 2 DAY)
            WHEN DAYOFWEEK(date_column) = 5 THEN DATE_SUB(date_column, INTERVAL 3 DAY)
            WHEN DAYOFWEEK(date_column) = 6 THEN DATE_SUB(date_column, INTERVAL 4 DAY)
            WHEN DAYOFWEEK(date_column) = 7 THEN DATE_SUB(date_column, INTERVAL 5 DAY)
        END,
        INTERVAL 6 DAY
    ) AS end_of_week
FROM your_table;