生日提醒功能(oracle)
select * from tmemberinfo where substr(szbirthday,6) in (select to_char(sysdate+rownum-1,'mm-dd')from dual connect by rownum<=7 );
生日提醒功能(oracle)
select * from tmemberinfo where substr(szbirthday,6) in (select to_char(sysdate+rownum-1,'mm-dd')from dual connect by rownum<=7 );