Use of TO_CHAR functions in Oracle

One, date format 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;

　　

Second, the number format conversion

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;

Three, Money format conversion

To_char (Salary, ' $99,99 ');

Select To_char (123, ' $99,999.9 ') from dual;

Four, binary conversion: 10 conversion into 16 binary

Select To_char (4567, ' xxxx ') from Dual;select to_char (123, ' xxx ') from dual;

　　

V. Examples

To_char Example
Input/Output
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 (' 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 (' 99v999 ') ' 12000 '
To_char (12.4, ' 99v999 ') ' 12400 '
To_char (12.45, ' 99v9 ') ' 125 '

Use of TO_CHAR functions in Oracle