oracle中如何将sysdate格式化为yyyy年mm月dd日？）

SELECT NAME_CN,lbl.AMT, CASE lbl.PERIOD_UNIT WHEN '1' THEN lbl.PERIOD WHEN '2' THEN lbl.PERIOD*30 END AS "period", pay_amt,
lbl.amt+lbl.amt*(CASE PERIOD_UNIT WHEN '1' THEN lbl.PERIOD WHEN '2' THEN lbl.PERIOD*30 END)*(interest_day_rate+service_day_rate)/100 "shouldRefund",
TO_CHAR(TO_DATE(expire_date,'yyyyMMdd'),'yyyy')||'年'||TO_CHAR(TO_DATE(expire_date,'yyyyMMdd'),'MM')||'月'||TO_CHAR(TO_DATE(expire_date,'yyyyMMdd'),'dd')||'日' AS "repay_datetime"
FROM QYD_APPLICATION_LOG qal
INNER JOIN USER_BASE_INFO ubi ON ubi.USER_ID = qal.borrower_user_id
INNER JOIN LOAN_BILL_LOG lbl ON lbl.bill_seq_no = qal.bill_seq_no
WHERE APPLY_SEQ_NO='0000000000000039';