ORACLE : SQL 將西元年轉民國年 (3位)

to_char(to_number(to_char(SYSDATE,'yyyy')) - 1911,'099')||to_char(SYSDATE,'/MM/DD')

097/06/25

http://horace1123.pixnet.net/blog/post/26380176

http://tw.myblog.yahoo.com/oracle-hmc/article?mid=13&l=f&fid=9