Hi All,
I am trying to convert string values to date, but the job is being failed to convert string to date when I was trying with Iconv function with the same string format.
I changed the structure to DD/MM/YYYY then I used Iconv(StrCol,"D/E")
still it is being failed.
Anyone can suggest me to be succeeded the job in loading date column values.
Thanks in advance.
string YYYYMMDD to DB2 date column
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 28
- Joined: Wed Jan 11, 2006 8:29 pm
- Location: Singapore
- Contact:
string YYYYMMDD to DB2 date column
Thnaks and Regards,
AnjiReddy.
AnjiReddy.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 28
- Joined: Wed Jan 11, 2006 8:29 pm
- Location: Singapore
- Contact: