DSXchange

Posted: **Thu Jul 01, 2010 2:32 am**

Hi,
I have extracted the data from oracle to datastage(oracle stage) .
but there is a change in the column data type.
when i extract a column of date type in oracle comes as timestamp in datastage why?

Thanks in davance

Posted: **Thu Jul 01, 2010 3:13 am**

Because Oracle stores all dates with a time component.

Oracle is... different.

Posted: **Thu Jul 01, 2010 5:40 am**

LOL... welcome to Larry's world.

Posted: **Sat Jul 03, 2010 4:02 am**

Should use : Given in below

Column SQL Type
Date VarChar

I believe it will work.

Posted: **Mon Jul 05, 2010 4:01 am**

@krishnuka123

why do you think it needs to be converted to Varchar to read a oracle date field?

In datastage it works perfectly fine using timestamp as datatype.

DSXchange

Date in oracle Timestamp in datastage

Date in oracle Timestamp in datastage