1.金额数字转字符类型

 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;

 

 

©️2020 CSDN 皮肤主题: 游动-白 设计师:上身试试 返回首页