Ext: http://blog.csdn.net/jiangnan2014/article/details/16908585
(1) As Date conversion:
to_char (date, ' format ');
Select To_date (' 2005-01-01 ', ' YYYY-MM-DD ') from dual;
Select To_char (sysdate, ' Yyyy-mm-dd HH24:mi:ss ') from dual;
(2) processing numbers:
to_char (number, ' format ');
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;
(3) To_char (Salary, ' $99,99 ');
Select To_char (123, ' $99,999.9 ') from dual;
(4) for conversion: convert 10 to 16;
Select To_char (4567, ' xxxx ') from dual;
Select To_char (123, ' xxx ') from dual;
Example:
1////To_char Example 2 input Output 3 To_char (now (), "Day, HH12:MI:SS") ' Tuesday, 05:39:18 ' 4 To_char (now (), ' Fmday, hh12:m I:ss ') ' Tuesday, 05:39:18 ' 5 to_char (-0.1, ' 99.99 ') '-.10 ' 6 to_char (-0.1, ' FM9.99 ') '-.1 ' 7 to_char (0.1, ' 0.9 ') ' 0.1 ' 8 to_char ( of, ' 9990999.9 ') ' 0012.0 ' 9 to_char ( of, ' 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 30 To_char (482, ' 999th ') ' 482nd ' to To_char (485, ' "Good number:"999') ' Good number:485' To_char (485.8, ' pre-decimal: "999"Post-decimal:".999') ' Pre-decimal:485Post-decimal:. A' To_char (' 99v999 ') '12000' To_char (12.4, ' 99v999 ') '12400' To_char (12.45, ' 99v9 ') ' the'