Quick Search:
 The Oracle TO_CHAR Function      [Return To Index] Jump to:  


The Oracle TO_CHAR function converts a string, date, a datetime-interval or a number into a character string.

If the first parameter is DATE type, it will be converted to a string representation. The resulting string style is specified with DATETYPE format elements which are optional parameters in the second parameter.

Example Syntax:

TO_CHAR (datetime_or_interval)
TO_CHAR (datetime_or_interval, 'format_string')
TO_CHAR (datetime_or_interval, 'format_string', 'nlsparam')

TO_CHAR (number)
TO_CHAR (number,'format_string')
TO_CHAR (number,'format_string', 'nlsparam')

For detailed examples of the available formatting options and their usage, please see the Related Link page below.

Related Links:

Related Code Snippets:
  • Date Functions: TO_CHAR - Converts DATE and TIMESTAMP to VARCHAR2 with the specified format.
  • ROWIDTONCHAR - ROWIDTONCHAR converts a rowid value to NVARCHAR2 datatype. The result of this conv...
  • TO_CHAR - Converts NCHAR, NVARCHAR2, CLOB, or NCLOB data to the database character set. The value ...
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org