• 2024-12-30Oracle计算自然周
    createorreplacefunctionGetweekbydate(sdateindate)returnnumberisResultnumber;beginselectto_char(decode(sign((to_date(to_char(sdate,'yyyymmdd'),'yyyymmdd')+