oracle 和 mysql 遍历当前月份每一天

最新推荐文章于 2025-01-17 15:40:15 发布

转载最新推荐文章于 2025-01-17 15:40:15 发布 · 349 阅读

1 ·

本内容遵循CC 4.0 BY-SA版权协议

原文链接：http://www.cnblogs.com/jpfss/p/11129500.html

标签

#数据库

收录于

获取当前月份的每一天的数据

oracle

SELECT TO_DATE(TO_CHAR(SYSDATE, 'YYYYMM'), 'YYYYMM') + (ROWNUM - 1) DAY_ID
  FROM DUAL
CONNECT BY ROWNUM <=
           TO_NUMBER(TO_CHAR(LAST_DAY(TO_DATE(TO_CHAR(SYSDATE, 'YYYYMM'),
                                              'YYYYMM')),
                             'DD'))

mysql

SELECT
  DATE_ADD(CURDATE(),INTERVAL(CAST(help_topic_id AS SIGNED INTEGER)-(DAYOFMONTH(CURDATE())-1)) DAY) DAY
FROM mysql.help_topic
WHERE help_topic_id < DAY(LAST_DAY(CURDATE()))
ORDER BY help_topic_id