Date in oracle Timestamp in datastage

ksk · Post by **ksk** » 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

ray.wurlod · Post by **ray.wurlod** » Thu Jul 01, 2010 3:13 am

Because Oracle stores all dates with a time component.

Oracle is... different.

chulett · Post by **chulett** » Thu Jul 01, 2010 5:40 am

LOL... welcome to Larry's world.

krishnuka123 · Post by **krishnuka123** » Sat Jul 03, 2010 4:02 am

Should use : Given in below

Column SQL Type
Date VarChar

I believe it will work.

priyadarshikunal · Post by **priyadarshikunal** » 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.