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 (Oracle) 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


Notes #

Click to create a new notes page