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.