SELECT
DATE_ADD( policy_end_time, INTERVAL '23:59:59' HOUR_SECOND ) AS newDate
FROM
policy_info
WHERE
RIGHT ( policy_end_time, 8 ) = '00:00:00';
红色部分为字段
SELECT
DATE_ADD( policy_end_time, INTERVAL '23:59:59' HOUR_SECOND ) AS newDate
FROM
policy_info
WHERE
RIGHT ( policy_end_time, 8 ) = '00:00:00';
红色部分为字段