方法一:
SELECT TO_CHAR(SYSDATE, 'YYYY"年"MM"月"DD"日"') A FROM dual
方法二:
SELECT
TO_CHAR(SYSDATE, 'YYYY') || '年' ||
TO_CHAR(SYSDATE, 'mm') || '月' ||
TO_CHAR(SYSDATE, 'dd') || '日'
A FROM dual
方法一:
SELECT TO_CHAR(SYSDATE, 'YYYY"年"MM"月"DD"日"') A FROM dual
方法二:
SELECT
TO_CHAR(SYSDATE, 'YYYY') || '年' ||
TO_CHAR(SYSDATE, 'mm') || '月' ||
TO_CHAR(SYSDATE, 'dd') || '日'
A FROM dual
转载于:https://my.oschina.net/chenhao901007/blog/364546