time格式mysql

-- 创建表并使用 TIME 类型
CREATE TABLE events (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_name VARCHAR(255),
    start_time TIME
);

-- 插入数据
INSERT INTO events (event_name, start_time) VALUES ('Meeting', '14:30:00');

-- 查询数据
SELECT * FROM events;

-- 使用内置函数计算时间间隔
SELECT TIMESTAMPDIFF(SECOND, '14:30:00', '15:45:00') AS seconds_diff;

-- 确保输入的时间格式正确
INSERT INTO events (event_name, start_time) VALUES ('Meeting', '14:30:00');

-- 检查时间范围
SELECT * FROM events WHERE start_time > '838:59:59' OR start_time < '-838:59:59';

-- 使用 STR_TO_DATE 函数
INSERT INTO events (event_name, start_time) VALUES ('Meeting', STR_TO_DATE('14:30:00', '%H:%i:%s'));