Page 1 of 1

Current GMT Timestamp

Posted: Mon Sep 17, 2007 8:45 am
by srikanthd1978
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

Posted: Mon Sep 17, 2007 3:51 pm
by ray.wurlod
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.