Converting String to Date
Posted: Mon Jan 30, 2006 7:04 am
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
please any one help for overcome this situation
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