I'm getting unexpected results from the local() function. My server is in ES

Jim Schweitzer

Certified Lead Developer

over 10 years ago

I'm getting unexpected results from the local() function. My server is in EST, but Jboss is set to run with -Duser.timezone=GMT
I'm on 7.10 Hotfix C. My user properly shows my timezone as America/New York, but when I use the local() function on a dateTime value, it subtracts an extra 5 hours from the time. See attached.

Discussion posts and replies are publicly visible

0 Eduardo Fuentes
Appian Employee
over 10 years ago

Can you attach a screenshot of System - Internationalization Settings?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jim Schweitzer
Certified Lead Developer
over 10 years ago

Was set to GMT. Tried changing it to EST. no effect
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jim Schweitzer
Certified Lead Developer
over 10 years ago

Attaching a screenshot not working so well from iPad...
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Eduardo Fuentes
Appian Employee
over 10 years ago

It seems the screenshot didn't make it to the post.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Jaggu over 10 years ago

As its mentioned in the local() definition it adds timezone offset to datetime, and here 'America/New York'/'EST' is (GMT - 5) so its adding -5 to current datetime and displaying properly.
Its looks like subtraction, and its actually adding - 5,

Am I correct or did I understand the question wrong
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel