select substr('2004-01-01',1,4)+floor((to_char(to_date('2004-01-01','yyyy-mm-dd'),'IW')+rownum-1)/53) as yearno||weeknum ,mod(to_char(to_date('2004-01-01','yyyy-mm-dd'),'IW')+rownum-1,53)+1 as weeknum from all_objects where rownum<=(to_date('2005-02-02','yyyy-mm-dd')- to_date('2004-01-01','yyyy-mm-dd'))/7+1
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货