DSXchange

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

TimestampOffsetByComponents
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.

- Parallel Job Developer's Guide

You supply the offset value(s)--positive or negative.

Failing that, your database is indeed a possibility. Load the file up into a "work" table and then use your DB function of choice when you extract it back out.

There are also web services out there that you can call, as yet another approach to solving this problem.