mysql年月截取

SELECT YEAR(order_date) AS order_year, MONTH(order_date) AS order_month FROM orders;

SELECT DATE_FORMAT(order_date, '%Y-%m') AS order_year_month FROM orders;

SELECT DATE_FORMAT(order_date, '%Y-%m') AS order_month, SUM(amount) AS total_amount
FROM orders
GROUP BY order_month;

-- 创建示例表
CREATE TABLE orders (
    order_id INT AUTO_INCREMENT PRIMARY KEY,
    order_date DATETIME,
    amount DECIMAL(10, 2)
);

-- 插入示例数据
INSERT INTO orders (order_date, amount) VALUES
('2023-01-15', 100.00),
('2023-01-20', 150.00),
('2023-02-10', 200.00),
('2023-02-25', 250.00);

-- 按月汇总订单金额
SELECT DATE_FORMAT(order_date, '%Y-%m') AS order_month, SUM(amount) AS total_amount
FROM orders
GROUP BY order_month;