SELECT
DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL n MONTH), '%Y%m') AS date
FROM (SELECT 0 n UNION ALL SELECT 1 UNION ALL SELECT 2 UNION ALL SELECT 3 UNION ALL SELECT 4 UNION ALL SELECT 5) tmp
WHERE DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL n MONTH), '%Y%m') >= DATE_FORMAT(DATE_SUB(CURDATE(), INTERVAL 5 MONTH),'%Y%m');
mysql中获取当前时间到前六个月的sql语句
最新推荐文章于 2024-07-30 02:10:48 发布