Current GMT Timestamp

srikanthd1978 · Post by **srikanthd1978** » Mon Sep 17, 2007 8:45 am

Hi folks,

I am trying to get the Current GMT Timestamp in one of my Parallel Jobs. The Target field is defined as a Timestamp on DB2 table.

When i use the CurrentTimestamp() function i get the Current Timetsamp of the Server where the Job is running.

Any ideas on how i can get the Vurrent GMT Timestamp using a xfm in DS Px Job.

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Sep 17, 2007 3:51 pm

In a Routine activity in a job sequence you can get it using System(99), which returns the system time in number of seconds since midnight Greenwich Mean Time (GMT), January 1, 1970.