上下五千年select (to_number(to_char(sysdate, yyyy))+5) benginyear ,(to_number(to_char(sysdate, y
上下五千年
select
(to_number(to_char(sysdate, 'yyyy'))+5) benginyear ,
(to_number(to_char(sysdate, 'yyyy'))-5) endyear
from dual
上下五千年
select
(to_number(to_char(sysdate, 'yyyy'))+5) benginyear ,
(to_number(to_char(sysdate, 'yyyy'))-5) endyear
from dual