最近7天要过生日的人
select *
from pcm_friends pf
where
((TO_CHAR(pf.birthday,'MM')=TO_CHAR(SYSDATE,'MM') AND TO_CHAR(pf.birthday,'dd')-TO_CHAR(SYSDATE,'DD')<=7 and TO_CHAR(pf.birthday,'dd')>TO_CHAR(SYSDATE,'DD'))
or(TO_CHAR(pf.birthday,'MM')-TO_CHAR(SYSDATE,'MM')=1 and TO_CHAR(sysdate,'dd')-TO_CHAR(pf.birthday,'DD')>=23)
or(TO_CHAR(sysdate,'MM')-TO_CHAR(pf.birthday,'MM')=11 and TO_CHAR(sysdate,'dd')-TO_CHAR(pf.birthday,'DD')>=23))and sysdate>pf.birthday
select *
from pcm_friends pf
where
((TO_CHAR(pf.birthday,'MM')=TO_CHAR(SYSDATE,'MM') AND TO_CHAR(pf.birthday,'dd')-TO_CHAR(SYSDATE,'DD')<=7 and TO_CHAR(pf.birthday,'dd')>TO_CHAR(SYSDATE,'DD'))
or(TO_CHAR(pf.birthday,'MM')-TO_CHAR(SYSDATE,'MM')=1 and TO_CHAR(sysdate,'dd')-TO_CHAR(pf.birthday,'DD')>=23)
or(TO_CHAR(sysdate,'MM')-TO_CHAR(pf.birthday,'MM')=11 and TO_CHAR(sysdate,'dd')-TO_CHAR(pf.birthday,'DD')>=23))and sysdate>pf.birthday