hi,
how can i have time zone(as pst,ist) in timestamp and have the time in GMT in parallel jobs?
date zone and GMT in parallel job
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not in a timestamp. The definition of a timestamp must coincide with the format of a timestamp.
The time zone is, of course, obtainable from the TZ environment variable so, if you convert your timestamp to a string, you can add in the time zone designator wherever you like.
GMT is somewhat trickier, because you must take into account the changeover dates for daylight saving ("summer time"), which are different in different parts of the world.
The time zone is, of course, obtainable from the TZ environment variable so, if you convert your timestamp to a string, you can add in the time zone designator wherever you like.
GMT is somewhat trickier, because you must take into account the changeover dates for daylight saving ("summer time"), which are different in different parts of the world.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.