TIME ZONE

RK72 · Post by **RK72** » Wed Jan 30, 2013 2:36 pm

HI
My source table has the field which has date and time which is coming from oracle so it is in the GMT time format so i want to convert it into CST. So i like to minus it by 6 hours so i like to know how can we do that in a transformer.

EX
source
2013-01-19 10:02:46

Like to see it as
2013-01-19 04:02:46

What would be the exact code to convert it.

Thanks

jwiles · Post by **jwiles** » Wed Jan 30, 2013 4:57 pm

Have you looked at the Date and Time functions available in your version of DataStage to see what might appear to be appropriate?

Regards,