Introducing Radical.sh

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

To_Date - Convert String to Date in Informatica

To_Date function converts input string into date, the format of input date can also be specified.

Example :
  1. // To _date example in Informatica
  2. TO_Date (DATE_PROMISED, 'MON DD YYYY' )

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



Syntax
  1. To_Date(string, [format])


When Format is not specified, Informatica expects the date in MM/DD/YYYY Fomat, if not it throws an error.


In the above example input string is provided in MON DD YYYY Format and Informatica Converts the string to Standard Date Format.