Date to be loaded to be manipulated

dscabtest · Post by **dscabtest** » Mon May 25, 2009 7:40 am

Hi,

I am very new to DataStage and I see that one is supposed to look through the forum to check if the question has been answered earlier, and I have. However, I wasn't lucky enough.
Could anyone please tell me how to best handle the case of a moving a date from one oracle table to another.
I have a date read from an Oracle table (one schema) and whilst moving it through the transform it is a timestamp (because there are no date types in DS). I need to load that timestamp field into the target oracle table (another schema) that expects a date. How do I handle this so that no warnings are generated.

Thanks,

Cameron

chulett · Post by **chulett** » Mon May 25, 2009 7:44 am

Welcome! :D

You are aware that Oracle DATE fields are, in essence, a Timestamp as they carry a time portion, yes? Have you tried simply carrying it through your job as a timestamp and loading it as such?

ps. The TIMESTAMP data type in Oracle adds fun stuff like milliseconds and TZ awareness, but for regular date and/or timestamp information people still use a DATE field.