Converting String to Date

[murali]

Hi all,
in my source definition the column datatype is varchar(10) and target data type is Date(10) I'm using db2 to db2 databases
I'm using DRS (DYNAMIC RDBMS) Stage both for source and table
The format of both source and target are yyyy-mm-dd
I'm getting following erro message

Code: Select all

Attempt to convert String value "2004-12-12" to Date type unsuccessful

please any one help for overcome this situation

[kcshankar]

Hi Murali,

Search the forum for "String value to Date type unsuccessful ",You will get lot of posts related to your topic.

regards
kcs