Hi All,
Good evening.
Is there a function ( or set of functions) that can convert a timestamp value (which is in EST) to GMT timestamp value ? I am trying to convert a timestamp field coming from an input file & it goes to a output file. ( so running a Currentimestamp-current timezone in DB2(as it is our Database) is not a possibillity)
Thanks for your thoughts in advance.
Freddie
Convert EST timestamp to GMT
Moderators: chulett, rschirm, roy
- Parallel Job Developer's GuideTimestampOffsetByComponents
Returns the given time stamp, with offsets applied from the given year offset, month offset, day offset, hour offset, minute offset, and second offset, each given as separate values. The seconds offset can include partial seconds.
You supply the offset value(s)--positive or negative.
Choose a job you love, and you will never have to work a day in your life. - Confucius
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: