1.金额数字转字符类型
to_char(ar.advance_amt,'9999999999999999999990.99') advanceAmt,
其中9带占位符
2.时间Date转字符类型
select ar.id receiptRecordNo,
to_char(ar.advance_amt,'9999999999999999999990.99') advanceAmt,
decode(t.advance_type,
'0',
'转账预收',
'1',
'支票预收',
'2',
'POS预收',
T.ADVANCE_TYPE) advanceType,
t.advance_account_flag as advanceAccountFlag,
to_char(t.advance_date, 'yyyy-MM-dd') as advanceDate,
to_char(t.advance_audit_date, 'yyyy-MM-dd') as advanceAuditDate,
FROM FRPS_ADVANCE_RECEIVE t, frps_advance_receive_record ar
WHERE t.is_valid = '1'
and t.receipt_no = ar.receipt_no
order by ar.updated_date desc;