mysql 获取指定和当前时间的差

CREATE TABLE events (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_time DATETIME
);

SELECT 
    event_time, 
    NOW(), 
    TIMESTAMPDIFF(SECOND, event_time, NOW()) AS time_difference_in_seconds,
    TIMESTAMPDIFF(MINUTE, event_time, NOW()) AS time_difference_in_minutes,
    TIMESTAMPDIFF(HOUR, event_time, NOW()) AS time_difference_in_hours,
    TIMESTAMPDIFF(DAY, event_time, NOW()) AS time_difference_in_days
FROM 
    events;

SELECT 
    event_time, 
    CONVERT_TZ(event_time, '+00:00', @@session.time_zone) AS event_time_local,
    TIMESTAMPDIFF(SECOND, CONVERT_TZ(event_time, '+00:00', @@session.time_zone), NOW()) AS time_difference_in_seconds
FROM 
    events;