--本周
select trunc(sysdate,'d')+1 from dual;--下周一
select trunc(sysdate,'d')+7from dual;
--本月
select trunc(sysdate,'mm') from dual;
select last_day(trunc(sysdate))from dual;
--本季
select trunc(sysdate,'Q')from dual;
select add_months(trunc(sysdate,'Q'),3)-1 from dual;
--本年
select trunc(sysdate,'yyyy') from dual;
select trunc(sysdate,'d')+1 from dual;--下周一
select trunc(sysdate,'d')+7from dual;
--本月
select trunc(sysdate,'mm') from dual;
select last_day(trunc(sysdate))from dual;
--本季
select trunc(sysdate,'Q')from dual;
select add_months(trunc(sysdate,'Q'),3)-1 from dual;
--本年
select trunc(sysdate,'yyyy') from dual;
select add_months(trunc(sysdate,'yyyy'),12)-1from dual;
--最近一个星期
(sysdate-book_date)=7
to_date(birthday, 'yyyy-mm-dd ') < sysdate -7
--最近一个月
maths_between(sysdate,book_date)=1