oracle获取上个月月份等操作
·
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;
更多推荐
所有评论(0)