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: #
CharacterErrors: #
NoneOperations: #
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