DSXchange

Posted: **Thu Sep 02, 2010 2:28 am**

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

Posted: **Thu Sep 02, 2010 2:45 am**

Maybe that is given as default or null value !?

Posted: **Thu Sep 02, 2010 6:43 pm**

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

Posted: **Fri Sep 03, 2010 2:21 am**

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

That is for you to check.

Posted: **Fri Sep 03, 2010 3:46 am**

yimwai wrote: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

Posted: **Fri Sep 03, 2010 4:46 am**

way246 wrote:
yimwai wrote: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,

DSXchange

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