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

转自：https://hacpai.com/article/1558144768869

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

注：help_topic 为 mysql 存储内置函数的表

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

标签：rac   rom   HERE   href   topic   ref   signed   ber   help

本条技术文章来源于互联网，如果无意侵犯您的权益请点击此处反馈版权投诉

本文系统来源：https://www.cnblogs.com/cchilei/p/12883060.html