This is version 1 2 3 4 . It is not the current version, and thus it cannot be edited.

Back to current versionRestore this version

TO_CHAR#

Functionality:#

This Oracle function converts a date or a number to a string or text format, with optional formatting.

Parameters:#

DATE/NUM	The date or number you want converted to text
Format	(optional) the format that the text should be returned in. See DATE FORMAT MODELS or NUMBER FORMAT MODELS (Oracle) for examples.

Returns: #

Character

Errors: #

None

Operations: #

This function is used to take a non-text format and convert it to a char.

Example:#

to_char(~) will convert the passed parameter to a character field. This may be necessary when subsequent operations expect a character value.

to_char(~,'YYYYMMDD') will convert the date passed to a character in format YYYYMMDD

to_char(~,'999v99MI') will convert the number passed to a character in format 999v99MI