Converting timestamp to GMT

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
shiva459
Premium Member
Premium Member
Posts: 100
Joined: Wed Jun 11, 2003 1:49 am
Location: Bangalore

Converting timestamp to GMT

Post by shiva459 »

Hello,

I have a requirement where in my input is timestamp in "YYYY-MM-DD HH:NN:SS" format.This input is from the same timezone.My output should be 2001-12-17T09:30:47-05:00 with GMT offset.How will I convert timestamp to GMT? How will I take care of the day light savings?

Thanks in advance,
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Do you mean generically, or just for the USA when changeover date is mandated by law (except for those states in which it is ignored)? Search the forum for other discussions around this question.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
shiva459
Premium Member
Premium Member
Posts: 100
Joined: Wed Jun 11, 2003 1:49 am
Location: Bangalore

Post by shiva459 »

Its only for USA
Post Reply