Hi All,
From source (.csv) file I have the date column value as 16-Dec-10 and when I try to load to Oracle with
StringToDate(Trim(Date1),"%dd-%mmm-%yyyy") error is thrown.
Transformer_130,0: Conversion error calling conversion routine date_from_string data may have been lost
The target Oracle table has the column as date.
Any suggestions please.
Thanks
Issue with String to date
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Your format string specifies a four-digit year - your incoming data has only a two digit year. That suggests that what you need to do is to change the format string to use a two digit year.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.