mysql怎么定义日期时间

-- 创建表并定义日期时间字段
CREATE TABLE events (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_name VARCHAR(255),
    start_time DATETIME,
    end_time TIMESTAMP
);

-- 插入数据
INSERT INTO events (event_name, start_time, end_time)
VALUES ('Conference', '2023-10-15 09:00:00', '2023-10-15 17:00:00');

-- 查询数据
SELECT * FROM events;

INSERT INTO events (event_name, start_time, end_time)
VALUES ('Conference', STR_TO_DATE('15-10-2023 09:00:00', '%d-%m-%Y %H:%i:%s'), '2023-10-15 17:00:00');

-- 创建表时指定时区
CREATE TABLE events (
    id INT AUTO_INCREMENT PRIMARY KEY,
    event_name VARCHAR(255),
    start_time DATETIME,
    end_time TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- 查询时进行时区转换
SELECT CONVERT_TZ(end_time, @@session.time_zone, '+08:00') AS end_time FROM events;