To_Char - Convert Integer or Date to String in Informatica

To_Char Functions any data type such as integer or decimal or date into string. To_Char Function act as Casting function in Informatica.
Formats used in To_CHAR
General Syntax
TO_CHAR( numeric_value )
TO_CHAR (date [, format ] )


Example : To Convert a integer to String
To_Char(10.666)

output
---------
'10.666'


Example : Date Formatting In Informatica
TO_CHAR (DATE_PROMISED, 'MON DD YYYY' )

Output
DATE_PROMISEDRETURN VALUE
Apr 1 1998 12:00:10AM'Apr 01 1998'

If Format is not specified, Informatica returns the output date in 'MM/DD/YYYY' Format.