Mysql 查询当前时间前4年的所有年月
SELECT
DATE_FORMAT( DATE_ADD( DATE_SUB( CURDATE(), INTERVAL 4 YEAR ), INTERVAL ( help_topic_id ) MONTH ), '%Y-%m' ) DT
FROM
mysql.help_topic
WHERE
help_topic_id < TIMESTAMPDIFF(
MONTH,
DATE_SUB( CURDATE(), INTERVAL 4 YEAR ),
CURDATE())
ORDER BY
DT DESC;
Oracle 查询当前时间前7天的所有日期
SELECT
to_char ( sysdate - LEVEL + 1, 'yyyy-mm-dd' ) cyrq_d
FROM
DUAL connect BY LEVEL <= 7