mysql 建表日期格式

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    registration_date DATE NOT NULL
);

CREATE TABLE orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    order_date DATETIME NOT NULL,
    total_amount DECIMAL(10, 2) NOT NULL,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

INSERT INTO users (username, email, registration_date)
VALUES ('john_doe', 'john@example.com', STR_TO_DATE('2023-10-05', '%Y-%m-%d'));

SET time_zone = '+08:00'; -- 设置时区为东八区
SELECT CONVERT_TZ(order_date, '+00:00', '+08:00') AS local_order_date FROM orders;

CREATE TABLE historical_events (
    event_id INT AUTO_INCREMENT PRIMARY KEY,
    event_name VARCHAR(100) NOT NULL,
    event_timestamp BIGINT NOT NULL
);