TO_CHAR(x [, format]) converts x to a string. : TO_CHAR « Conversion Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Conversion Functions
  3. TO_CHAR

You can provide an optional format that indicates the format of x.

The structure format depends on whether x is a number or date.

The following example converts 12345.67 to a string:

SQL> SELECT TO_CHAR(12345.67) FROM dual;

TO_CHAR(
--------
12345.67

SQL>








15.7.TO_CHAR
15.7.1.Format Parameters
15.7.2.TO_CHAR(x [, format]) converts x to a string.
15.7.3.TO_CHAR() will return a string of pound characters (#) if you try and format a number that contains too many digits for the format you have provided.
15.7.4.Use TO_CHAR() to convert columns containing numbers to strings.
15.7.5.TO_CHAR(12345.67, '99,999.99') (1)
15.7.6.TO_CHAR(12345.67, '99999.99') (2)
15.7.7.TO_CHAR(-12345.67, '99,999.99') (3)
15.7.8.TO_CHAR(12345.67, '099,999.99') (4)
15.7.9.TO_CHAR(12345.67, '99,999.9900')
15.7.10.TO_CHAR(12345.67, '$99,999.99')
15.7.11.TO_CHAR(0.67, 'B9.99')
15.7.12.TO_CHAR(12345.67, 'C99,999.99')
15.7.13.TO_CHAR(12345.67, '99999D99')
15.7.14.TO_CHAR(12345.67, '99999.99EEEE')
15.7.15.TO_CHAR(0012345.6700, 'FM99999.99')
15.7.16.TO_CHAR(12345.67, '99999G99')
15.7.17.TO_CHAR(12345.67, 'L99,999.99')
15.7.18.TO_CHAR(-12345.67, '99,999.99MI')
15.7.19.TO_CHAR(-12345.67, '99,999.99PR')
15.7.20.TO_CHAR(2007, 'RN')
15.7.21.TO_CHAR(12345.67, 'TM')
15.7.22.TO_CHAR(12345.67, 'U99,999.99')
15.7.23.TO_CHAR(12345.67, '99999V99')
15.7.24.TO_CHAR(last_ddl_time,'dd-mon-yyyy hh24:mi')
15.7.25.to_char(sysdate,'hh24:mi:ss') as time
15.7.26.to_char(to_date('01/01/2006','dd/mm/yyyy'),is on Day') as new_year_2006
15.7.27.to_char(sysdate, 'Day', 'nls_date_language=Dutch')
15.7.28.to_char(sysdate,'DAY dy Dy')
15.7.29.to_char(sysdate,'MONTH mon') as month
15.7.30.to_char(bdate,'fmMonth ddth, yyyy')
15.7.31.use to_char more than once to create long date format