mysql计算两个时间戳差

-- 使用 TIMESTAMPDIFF 函数计算秒数差值
SELECT TIMESTAMPDIFF(SECOND, start_time, end_time) AS seconds_diff;

-- 使用 TIMESTAMPDIFF 函数计算分钟数差值
SELECT TIMESTAMPDIFF(MINUTE, start_time, end_time) AS minutes_diff;

-- 使用 TIMESTAMPDIFF 函数计算小时数差值
SELECT TIMESTAMPDIFF(HOUR, start_time, min_time) AS hours_diff;

-- 使用 DATEDIFF 函数计算天数差值
SELECT DATEDIFF(end_time, start_time) AS days_diff;

-- 检查时间戳格式
SELECT start_time, end_time FROM your_table WHERE start_time IS NOT NULL AND end_time IS NOT NULL;

-- 转换时间戳格式
UPDATE your_table SET start_time = FROM_UNIXTIME(start_time) WHERE start_time IS NOT NULL;

-- 设置时区
SET time_zone = '+8:00';

-- 使用正确的数据类型
ALTER TABLE your_table MODIFY COLUMN start_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP;
ALTER TABLE your_table MODIFY COLUMN end_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP;