select decode(to_char(sysdate,'mm')-1,0,to_char(sysdate,'yyyy')-1,to_char(sysdate,'yyyy'))||case when to_number(decode(to_char(sysdate,'mm')-1,0,12,to_char(sysdate,'mm')-1)) < 10 then '0'||decode(to_char(sysdate,'mm')-1,0,12,to_char(sysdate,'mm')-1) else ''||decode(to_char(sysdate,'mm')-1,0,12,to_char(sysdate,'mm')-1) end datev from dual
取上个月月份的SQL
最新推荐文章于 2024-08-06 17:03:59 发布