1.查询上月末的日期:
select last_day(add_months(sysdate,-1)) from dual;
2.查询本周星期一的日期:
select trunc(sysdate,'day' ) + 1 from dual ;
3.计算年初至今的天数:
select ceil(sysdate-trunc(sysdate,'year')) from dual;
4.查询今天是今年的第几周:
select to_char(sysdate,'fmww') from dual;
5.查询今天是本月的第几周:
select to_char(sysdate,'ww') - to_char(trunc(sysdate,'mm'),'ww') from dual;
6.查询本月的天数:
select to_char(last_day(sysdate),'dd') days from dual;
7. 查询今年的天数:
select add_months(trunc(sysdate,'year'),12) - trunc(sysdate,'year') from dual;
8.查询下周一的日期:
select next_day(sysdate,'下周一日期') from dual;