Data string '01/01/1900' does not match format %yyyy-%mm-%d

[nani0907]

you need to bring the date format asyyyy-%mm-%dd' by using to_char option in query. Giva a try

[Sainath.Srinivasan]

Maybe that is given as default or null value !?

[yimwai]

but why null value or default value can be '01/01/1900'

[Sainath.Srinivasan]

but why null value or default value can be '01/01/1900'

That is for you to check.

[way246]

but why null value or default value can be '01/01/1900'

It is due to insert/update statements run with "" value for datetime field

[ramsubbiah]

but why null value or default value can be '01/01/1900'

It is due to insert/update statements run with "" value for datetime field

the datastage will assign the "1900-01-01" as default(null) value for date field,