上个月月初
SELECT TRUNC(ADD_MONTHS(TO_DATE(‘20220117’,‘YYYYMMDD’),-1),‘MM’) FROM DUAL;
SELECT ADD_MONTHS (TRUNC(TO_DATE(‘20220331’,‘YYYYMMDD’),‘MM’),-1) FROM DUAL;
sql上个月月初
最新推荐文章于 2024-02-02 23:43:18 发布
上个月月初
SELECT TRUNC(ADD_MONTHS(TO_DATE(‘20220117’,‘YYYYMMDD’),-1),‘MM’) FROM DUAL;
SELECT ADD_MONTHS (TRUNC(TO_DATE(‘20220331’,‘YYYYMMDD’),‘MM’),-1) FROM DUAL;