mysql日期datetime比较

SELECT * FROM table_name WHERE datetime_column > '2023-01-01 00:00:00';

SELECT DATE_FORMAT(datetime_column, '%Y-%m-%d') AS formatted_date FROM table_name;

SELECT TIMESTAMPDIFF(SECOND, datetime_column1, datetime_column2) AS diff_in_seconds FROM table_name;

-- 创建一个示例表
CREATE TABLE example_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_time DATETIME
);

-- 插入一些示例数据
INSERT INTO example_table (event_time) VALUES
('2023-01-01 12:00:00'),
('2023-01-02 12:00:00'),
('2023-01-03 12:00:00');

-- 查询特定时间之后的记录
SELECT * FROM example_table WHERE event_time > '2023-01-02 00:00:00';

-- 格式化时间
SELECT id, DATE_FORMAT(event_time, '%Y-%m-%d') AS formatted_date FROM example_table;