TimeStamp with milliseconds in PX job

kalyang · Post by **kalyang** » Fri Mar 24, 2006 1:50 am

Hi There,

How do I get the current time with milliseconds and time zone in parallel job?

(i.e. format) yyyy-MM-dd HH:mm:ss.SSS zzz

where zzz is three dig Zone.

Kalyan.G

chulett · Post by **chulett** » Fri Mar 24, 2006 6:50 am

Not asking for much, eh? Milliseconds and a timezone. :lol:

Check this post from our dear friend Arnd, it covers the milliseconds part and can probably be leveraged for both.

kumar_s · Post by **kumar_s** » Fri Mar 24, 2006 7:08 am

There isnt any inbuilt funciton available for extracting TimeZone. You need to do workaroud to capture that. Else you can use D code, Iconv,Oconv from UserVariableActivity and pass on the value as a parameter. (If required as a single value as a whole for that job)

ray.wurlod · Post by **ray.wurlod** » Fri Mar 24, 2006 3:53 pm

You can get the GMT time from the System() function, so presumably can get the offset via arithmetic. And, of course, you can get the time zone from the TZ environment variable.

In what format do you require this "timestamp"?

kumar_s · Post by **kumar_s** » Sat Mar 25, 2006 5:27 am

May I know is TZ environmential variable for PX?
Also I guess System() function is not a PX funciton.

ray.wurlod · Post by **ray.wurlod** » Sat Mar 25, 2006 2:35 pm

TZ is a standard UNIX environment variable. You could therefore define it for PX with a default value of $ENV.
System() is a BASIC function. You could therefore create a routine to be invoked from a Routine activity in a job sequence.