!!!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'}]