select a from ( select a,row_number()over(order by a desc) rn from ( select to_char(t.d,'yy-mm-dd') a from ( select trunc(to_date('2010-08-10','yyyy-mm-dd'),'mm')+rownum-1 d from dba_objects where rownum<32 )t where to_char(t.d,'mm')=to_char(to_date('2010-08-10','yyyy-mm-dd'),'mm') and to_char(t.d,'day')='星期三' ) ) where rn=2 --result: 10-08-18--把日期改一下就可以得出那个月的值了!
select next_day(last_day(trunc(sysdate,'mm'))-14,'星期三') from dual
from
(
select a,row_number()over(order by a desc) rn
from
(
select to_char(t.d,'yy-mm-dd') a
from
(
select trunc(to_date('2010-08-10','yyyy-mm-dd'),'mm')+rownum-1 d
from dba_objects where rownum<32
)t
where to_char(t.d,'mm')=to_char(to_date('2010-08-10','yyyy-mm-dd'),'mm')
and to_char(t.d,'day')='星期三'
)
)
where rn=2
--result:
10-08-18--把日期改一下就可以得出那个月的值了!
next_day(last_day(trunc(sysdate,'mm'))-14,'星期三')
from dual