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

Example :

// To _date example in Informatica
TO_Date (DATE_PROMISED, 'MON DD YYYY' )

DATE_PROMISED	RETURN VALUE
'Apr 01 1998'	Apr 1 1998 12:00:10AM

Syntax

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.