oracle 中to_char函数的用法
一、日期格式转换
to_char(date,'格式');
1 2 | select to_date( '2005-01-01 ' , 'yyyy-MM-dd' ) from dual; select to_char(sysdate, 'yyyy-MM-dd HH24:mi:ss' ) from dual; |
二、数字格式转换
to_char(number,'格式');
1 2 3 4 5 | select to_char( 88877 ) from dual; select to_char( 1234567890 , '099999999999999' ) from dual; select to_char( 12345678 , '999,999,999,999' ) from dual; select to_char( 123456 , '99.999' ) from dual; select to_char( 1234567890 , '999,999,999,999.9999' ) from dual; |
三、金钱格式转换
to_char(salary,'$99,99');
1 | select TO_CHAR( 123 , '$99,999.9' ) from dual; |
四、进制转换:10进制转化为16进制
1 2 | select to_char( 4567 , 'xxxx' ) from dual; select to_char( 123 , 'xxx' ) from dual; |
五、例子
//// to_char 例子
输入 输出
to_char(now(),'Day, HH12:MI:SS') 'Tuesday , 05:39:18'
to_char(now(),'FMDay, HH12:MI:SS') 'Tuesday, 05:39:18'
to_char(-0.1,'99.99') ' -.10'
to_char(-0.1,'FM9.99') '-.1'
to_char(0.1,'0.9') ' 0.1'
to_char(12,'9990999.9') ' 0012.0'
to_char(12,'FM9990999.9') '0012'
to_char(485,'999') ' 485'
to_char(-485,'999') '-485'
to_char(485,'9 9 9') ' 4 8 5'
to_char(1485,'9,999') ' 1,485'
to_char(1485,'9G999') ' 1 485'
to_char(148.5,'999.999') ' 148.500'
to_char(148.5,'999D999') ' 148,500'
to_char(3148.5,'9G999D999') ' 3 148,500'
to_char(-485,'999S') '485-'
to_char(-485,'999MI') '485-'
to_char(485,'999MI') '485'
to_char(485,'PL999') '+485'
to_char(485,'SG999') '+485'
to_char(-485,'SG999') '-485'
to_char(-485,'9SG99') '4-85'
to_char(-485,'999PR') '<485>'
to_char(485,'L999') 'DM 485
to_char(485,'RN') ' CDLXXXV'
to_char(485,'FMRN') 'CDLXXXV'
to_char(5.2,'FMRN') V
to_char(482,'999th') ' 482nd'
to_char(485, '"Good number:"999') 'Good number: 485'
to_char(485.8,'"Pre-decimal:"999" Post-decimal:" .999') 'Pre-decimal: 485 Post-decimal: .800'
to_char(12,'99V999') ' 12000'
to_char(12.4,'99V999') ' 12400'
to_char(12.45, '99V9') ' 125'
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步