How to get current datetime in GMT

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
nguyenmk
Participant
Posts: 5
Joined: Tue Mar 14, 2006 5:06 pm

How to get current datetime in GMT

Post by nguyenmk »

Hi,

Is there a tranform in Parallel Server that does the same thing as DateCurrentGMTTime transform in Server? I need to get the currrent timestamp in GMT in Parallel Server.

Thanks.
bcarlson
Premium Member
Premium Member
Posts: 772
Joined: Fri Oct 01, 2004 3:06 pm
Location: Minnesota

Post by bcarlson »

I don't know about Tranforms, but in buildops there are a coupld of functions called localTime() and localTimeStamp(). These represent whatever your local time is, where as the function now() represents it as GMT.

From what I have seen there is usually a corresponding Transform function for every function in buildops.


Brad.
nguyenmk
Participant
Posts: 5
Joined: Tue Mar 14, 2006 5:06 pm

Post by nguyenmk »

Brad,

I couldn't find any of the functions you mentioned in the buildops. I would like to use the function or transform in the transformer stage if they are available.

Thanks,

Michael
bcarlson
Premium Member
Premium Member
Posts: 772
Joined: Fri Oct 01, 2004 3:06 pm
Location: Minnesota

Post by bcarlson »

Sorry, I should clarify - There usually is a corresponding function, but the name may be slightly different.
Post Reply