Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle TO_CHAR Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

Term: TO_CHAR

Definition:
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(nchar_clob_or_nclob)
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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 236 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?