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

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