mysql 日期查询

SELECT * FROM your_table WHERE date_column BETWEEN '2023-01-01' AND '2023-12-31';

SELECT * FROM your_table WHERE date_column >= '2023-01-01' AND date_column <= '2023-12-31';

-- 查询某个月的第一天
SELECT DATE_FORMAT('2023-02-15', '%Y-%m-01') AS first_day;

-- 查询某个月的最后一天
SELECT LAST_DAY('2023-02-15') AS last_day;

SELECT CONVERT_TZ('2023-02-15 12:00:00', '+08:00', '+00:00') AS utc_time;

-- 创建表
CREATE TABLE orders (
    id INT AUTO_INCREMENT PRIMARY KEY,
    order_date DATETIME NOT NULL,
    total_amount DECIMAL(10, 2) NOT NULL
);

-- 插入示例数据
INSERT INTO orders (order_date, total_amount) VALUES
('2023-01-15 10:30:00', 150.00),
('2023-02-20 14:45:00', 200.00),
('2023-03-10 09:15:00', 75.50);

-- 查询2023年第一季度的订单
SELECT * FROM orders WHERE order_date BETWEEN '2023-01-01' AND '2023-03-31';