SELECT TO_CHAR(ADD_MONTHS(LAST_DAY(ADD_MONTHS(SYSDATE, -1)) + 1, -1), 'yyyy/mm/dd') AS 上个月最第一天,
       TO_CHAR(LAST_DAY(ADD_MONTHS(SYSDATE, -1)), 'yyyy/mm/dd') AS 上个月最后一天,
       TO_CHAR(ADD_MONTHS(SYSDATE, -1), 'MM') AS 上个月月份,
       EXTRACT(YEAR FROM SYSDATE) AS 当前年份
  FROM DUAL;
Logo

北京人形旗下天工造物具身智能开源社区,聚焦具身天工与慧思开物两大平台

更多推荐