Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
3 replies
Subscribers
7 subscribers
Views
1992 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
I am needing some help with date field issues. I have a date field that I
marieh
over 8 years ago
I am needing some help with date field issues.
I have a date field that I am saving to the db as local(now()). Then when it gets pulled from the db it is one day in the past. Then when I display it with local or with out local it is two days in the past. I have even got rid of the local when saving to db and it still does the same thing. Does any one have any suggestions?
OriginalPostID-174405
OriginalPostID-174405
Discussion posts and replies are publicly visible
Parents
0
peterf
over 8 years ago
Local applies a fixed time zone offset relative to GMT - not relative to your process model time, so if your process model is set to use your local timezone I would expect this to give an invalid result. Even though your database may store date/time values as GMT (that is normal practice) it is rendered in the user or process model time zone after it is read back from the DB
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
peterf
over 8 years ago
Local applies a fixed time zone offset relative to GMT - not relative to your process model time, so if your process model is set to use your local timezone I would expect this to give an invalid result. Even though your database may store date/time values as GMT (that is normal practice) it is rendered in the user or process model time zone after it is read back from the DB
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data