Date conversion in informatica

Question

I am loading date fields from file to teradata table. In a file my date format is mm-dd-yyyy and in my teradata table the format is yyyy/mm/dd.

I used the below function for formatting:

To_date(to_char(date field,'mm-dd-yyyy'),'yyyy/mm/dd')
But all my records are going in rejected records. When I checked session log my date field was mentioned as invalid date.

Please help on this.

Answer 1

try - To_char(to_date(date field,'mm-dd-yyyy'),'yyyy/mm/dd')

This will work

Answer 2

Use to_date(datefield,'mm-dd-yyyy ')