Originally posted by: snutakki

In Mercator is there a way to know whether the CURRENT TIME is Day Light Savings time or Standard time ????
thanks,
cai
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender
#DataExchange

Originally posted by: rajom777

Will be the time of the server where the map is deployed.In case of windows, the system time. Day Light Savings time or Standard time is set by the admin as applicable. Please correct me if i am wrong.
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender

Originally posted by: snutakki

Yes you are right the times are set by the admin on the servers.
My question was whether the below logic will work or not when my maps are running on a UNIX server

IF (MID ( FROMDATETIME ( CURRENTTIME ( ), "{ZZZ}"),2, 1)="S", "ET",
IF (MID ( FROMDATETIME ( CURRENTTIME ( ), "{ZZZ}"), 2, 1)="D", "ED" ))

So when we go to Day Light savings time while Mercator return for Zone "EDT" ???
thanks,
cai
#IBM-Websphere-Transformation-Extender
#DataExchange
#IBMSterlingTransformationExtender

Originally posted by: ChB

Hello group,

an old thread, but a new question: we are running WTX 8.3.0.2 with Solaris 10.

The bash date command looks OK:

bash-3.00$ date -u
Monday, August 15, 2011 3:09:51 PM GMT
bash-3.00$ date
Monday, August 15, 2011 5:09:58 PM MEST

We have currently summer time (MEST) and we have two hours difference to the GMT.
But if I use

=FROMDATETIME(CURRENTDATETIME(),"HH24:MM:SS ZZZ +/-ZZ:ZZ")

in a rule (we use ZZZ and +/-ZZ:ZZ for testing reason) it produces the following output:

17:10:19 CET +01:00

Why CET and why only 1 hour. Do you have an idea, where the function gets the information from? Are other WTX functions possible? Can it be a bug? Is there another option I should check with Solaris?

Thanks in advance for any hint

Christian
#DataExchange
#IBMSterlingTransformationExtender
#IBM-Websphere-Transformation-Extender