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