!!!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