在mysql中获取不同时间段的具体数据

-- 获取今天的订单
SELECT * FROM orders WHERE DATE(order_date) = CURDATE();

-- 获取昨天的订单
SELECT * FROM orders WHERE DATE(order_date) = CURDATE() - INTERVAL 1 DAY;

-- 获取本周的订单
SELECT * FROM orders WHERE WEEK(order_date) = WEEK(NOW());

-- 获取上周的订单
SELECT * FROM orders WHERE WEEK(order_date) = WEEK(NOW()) - 1;

-- 获取本月的订单
SELECT * FROM orders WHERE MONTH(order_date) = MONTH(NOW());

-- 获取上月的订单
SELECT * FROM orders WHERE MONTH(order_date) = MONTH(NOW()) - 1;

-- 获取今年的订单
SELECT * FROM orders WHERE YEAR(order_date) = YEAR(NOW());

-- 获取去年的订单
SELECT * FROM orders WHERE YEAR(order_date) = YEAR(NOW()) - 1;

-- 获取指定时间段的订单
SELECT * FROM orders WHERE order_date BETWEEN '2022-01-01' AND '2022-12-31';