日期:2014-05-17 浏览次数:20853 次
select * from tb where to_char(birthday, 'mmdd') in (select to_char(sysdate + level, 'mmdd') A from dual connect by level <= 30)
select * from t where to_char(m_date,'mmdd')<=to_char((sysdate+30),'mmdd');