Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date Format Conversion

Status
Not open for further replies.

sa0309

Programmer
Apr 5, 2010
45
US
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
 
Your Suggestion should work - I hope you have already tried this.

Let me know if you still have issues - I see if we have run into this before.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top