西元年 -> 民國年
Select (to_number(to_char(sysdate,’yyyy’)) – 1911)to_char(sysdate,’/MM/DD HH24:MI:SS’) AS AAD from dual;
select to_char(add_months(sysdate,-(1911*12)),’YY/MM/DD HH24:MI:SS’) from dual;
select add_months(sysdate,-(1911*12)) from dual
Select (to_number(to_char(sysdate,’yyyy’)) – 1911)to_char(sysdate,’/MM/DD HH24:MI:SS’) AS AAD from dual;
select to_char(add_months(sysdate,-(1911*12)),’YY/MM/DD HH24:MI:SS’) from dual;
select add_months(sysdate,-(1911*12)) from dual