西元年 -> 民國年

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

-t
---
Tyson Chen
tysonchen () gmail