使い方:SYSDATEがDB項目に変更
平成Z9年Z9月Z9日:
SELECT
(TO_CHAR(SYSDATE,'EE','NLS_CALENDAR=''JapaneseImperial''') ||
TO_NUMBER(TO_CHAR(SYSDATE,'YY','NLS_CALENDAR=''JapaneseImperial'''),'09') || '年' ||
TO_NUMBER(TO_CHAR(SYSDATE,'MM','NLS_CALENDAR=''JapaneseImperial'''),'09') || '月' ||
TO_NUMBER(TO_CHAR(SYSDATE,'DD','NLS_CALENDAR=''JapaneseImperial'''),'09') || '日')
FROM DUAL
HZ9.Z9.Z9:
SELECT
(TO_CHAR(SYSDATE,'E','NLS_CALENDAR=''JapaneseImperial''') ||
TO_NUMBER(TO_CHAR(SYSDATE,'YY','NLS_CALENDAR=''JapaneseImperial'''),'09') || '.' ||
TO_NUMBER(TO_CHAR(SYSDATE,'MM','NLS_CALENDAR=''JapaneseImperial'''),'09') || '.' ||
TO_NUMBER(TO_CHAR(SYSDATE,'DD','NLS_CALENDAR=''JapaneseImperial'''),'09'))
FROM DUAL