!!!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|Edit:Internal.TO_CHAR] 	
[{InsertPage page='Internal.TO_CHAR' default='Click to create a new notes page'}]