Search For
Flagging a Snippet, takes the snippet to Moderator Attention;


0
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.
Vote! You feel this code is working like charm ? Go a head Login and Press up arrow.
Didn't work ?, press down arrow and let us know the error in comments

Comments