17,377
社区成员
发帖
与我相关
我的任务
分享
select to_char(last_day(add_months(sysdate,-2))+1,'yyyy-mm-dd') from dual;
select to_char(last_day(add_months(sysdate,-2))+1,'yyyy-mm-dd') from dual;
select to_char(last_day(add_months(sysdate,-2))+1,'yyyy-mm-dd') from dual;
select add_months(last_day(trunc(sysdate)),-2)+1 from dual;
select trunc(trunc(sysdate, 'month') - 1, 'month') from dual;
select to_char(trunc(add_months(last_day(sysdate), -2) + 1), 'yyyy-MM-dd hh24:mi:ss') "上月第一天",
to_char(trunc(add_months(last_day(sysdate), -1) + 1), 'yyyy-MM-dd hh24:mi:ss') "本月第一天",
to_char(last_day(sysdate), 'yyyy-mm-dd hh24:mi:ss') "本月最后一天"
from dual;
select trunc(add_months(sysdate,-1),'mm') from dual;