mysql 取时间的季度

-- 获取当前日期所属的季度
SELECT 
    CASE 
        WHEN MONTH(CURDATE()) IN (1, 2, 3) THEN 'Q1'
        WHEN MONTH(CURDATE()) IN (4, 5, 6) THEN 'Q2'
        WHEN MONTH(CURDATE()) IN (7, 8, 9) THEN 'Q3'
        ELSE 'Q4'
    END AS quarter;

-- 获取指定日期所属的季度
SELECT 
    CASE 
        WHEN MONTH('2023-05-15') IN (1, 2, 3) THEN 'Q1'
        WHEN MONTH('2023-05-15') IN (4, 5, 6) THEN 'Q2'
        WHEN MONTH('2023-05-15') IN (7, 8, 9) THEN 'Q3'
        ELSE 'Q4'
    END AS quarter;

SELECT 
    CASE 
        WHEN MONTH('2022-12-15') IN (1, 2, 3) THEN CONCAT(YEAR('2022-12-15'), '-Q1')
        WHEN MONTH('2022-12-15') IN (4, 5, 6) THEN CONCAT(YEAR('2022-12-15'), '-Q2')
        WHEN MONTH('2022-12-15') IN (7, 8, 9) THEN CONCAT(YEAR('2022-12-15'), '-Q3')
        ELSE CONCAT(YEAR('2022-12-15'), '-Q4')
    END AS quarter;