My source is a CSV file. It contains several date/times columns in the following format ( MM/DD/YYYY HH:MI )
DateField1
10/13/2008 10:40
10/13/2008 11:22
10/13/2008 12:50
10/13/2008 14:40
10/13/2008 15:01
If I recall, Informatica doesn't support to_date conversions without the seconds in the format.
Will I have to just concatenate ( DateField1||:00 ) on the end and then use MM/DD/YYYY HH24:MI:SS ?
Any suggestions would be appreciated.
Thanks in advance
DateField1
10/13/2008 10:40
10/13/2008 11:22
10/13/2008 12:50
10/13/2008 14:40
10/13/2008 15:01
If I recall, Informatica doesn't support to_date conversions without the seconds in the format.
Will I have to just concatenate ( DateField1||:00 ) on the end and then use MM/DD/YYYY HH24:MI:SS ?
Any suggestions would be appreciated.
Thanks in advance