mysql 判断两个时间是否同一天

SELECT 
    CASE 
        WHEN DATE(time1) = DATE(time2) THEN '同一天'
        ELSE '不是同一天'
    END AS result
FROM your_table;

SELECT 
    CASE 
        WHEN DATEDIFF(time1, time2) = 0 THEN '同一天'
        ELSE '不是同一天'
    END AS result
FROM your_table;

SELECT 
    CASE 
        WHEN DATE(STR_TO_DATE(time1, '%Y-%m-%d %H:%i:%s')) = DATE(STR_TO_DATE(time2, '%Y-%m-%d %H:%i:%s')) THEN '同一天'
        ELSE '不是同一天'
    END AS result
FROM your_table;

SELECT 
    CASE 
        WHEN DATE(CONVERT_TZ(time1, '+00:00', 'Asia/Shanghai')) = DATE(CONVERT_TZ(time2, '+00:00', 'Asia/Shanghai')) THEN '同一天'
        ELSE '不是同一天'
    END AS result
FROM your_table;