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

Jim Schweitzer

Certified Lead Developer

over 9 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 9 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 9 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 9 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 9 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 9 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