mysql时间减去时间

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

SELECT 
    event_name,
    event_time,
    TIMESTAMPDIFF(SECOND, (SELECT event_time FROM events WHERE id = 1), event_time) AS time_diff_in_seconds
FROM 
    events
WHERE 
    id > 1;

SELECT 
    event_name,
    CONVERT_TZ(event_time, '+00:00', @@session.time_zone) AS event_time_utc,
    TIMESTAMPDIFF(SECOND, (SELECT CONVERT_TZ(event_time, '+00:00', @@session.time_zone) FROM events WHERE id = 1), CONVERT_TZ(event_time, '+00:00', @@session.time_zone)) AS time_diff_in_seconds
FROM 
    events
WHERE 
    id > 1;

SELECT 
    event_name,
    DATE_FORMAT(event_time, '%Y-%m-%d %H:%i:%s') AS formatted_event_time
FROM 
    events;