Introducing Radical.sh

Forget Code launches a powerful code generator for building API's

To_Char - Convert Integer or Date to String in Informatica

  1. Forget Code
  2. Informatica
  3. To_Char - Convert Integer or Date to String
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
  1. TO_CHAR( numeric_value )
  2. TO_CHAR (date [, format ] )


Example : To Convert a integer to String
  1. To_Char(10.666)
  2.  
  3. output
  4. ---------
  5. '10.666'


Example : Date Formatting In Informatica
  1. 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.