SQL查询中当前季度之前的最大日期

SELECT MAX(date_column) AS max_date
FROM table_name
WHERE 
    CASE 
        WHEN MONTH(CURRENT_DATE()) BETWEEN 1 AND 3 THEN date_column <= DATE_FORMAT(CURRENT_DATE(), '%Y-03-31')
        WHEN MONTH(CURRENT_DATE()) BETWEEN 4 AND 6 THEN date_column <= DATE_FORMAT(CURRENT_DATE(), '%Y-06-30')
        WHEN MONTH(CURRENT_DATE()) BETWEEN 7 AND 9 THEN date_column <= DATE_FORMAT(CURRENT_DATE(), '%Y-09-30')
        WHEN MONTH(CURRENT_DATE()) BETWEEN 10 AND 12 THEN date_column <= DATE_FORMAT(CURRENT_DATE(), '%Y-12-31')
    END