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
7 replies
Subscribers
8 subscribers
Views
5276 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Hi. I am displaying the date time field on UI which is defaulted to previous day
jaishankarj
over 9 years ago
Hi. I am displaying the date time field on UI which is defaulted to previous day 00:00. But due to BST change my date time is getting displayed 1 hour ahead 01:00. I can wrap my datetime in gmt() function and get the desired result but this will force me to change it again when BST ends. Is there a better way to handle this?
Code Snippet:
Displaying date time using - todatetime(today() - 1) - results as dd/mm/yyyy 00:00 (dd/mm/yyyy 01:00 after daylight saving)
Fixed this using gmt () - gmt(todatetime(today() - 1)) - results as dd/mm/yyyy 00:00 ( do I have to change the code when daylight savings ends?)
OriginalPostID-203712
OriginalPostID-203712
Discussion posts and replies are publicly visible
Parents
0
siddharthg837
over 9 years ago
One of the approach to cater this is to change the timezone value prior to storing in database for which you can use gmt() or local() functions. But store your datetime values in the database in GMT to avoid this sort of problems. Please go through time zone context, date and time functions to understand in detail.
forum.appian.com/.../Time_Zone_Context
forum.appian.com/.../Date_and_Time_Functions
forum.appian.com/.../Date_and_Time_Functions
forum.appian.com/.../Data_Types
forum.appian.com/.../Date_and_Time_Functions
The similar post around this which might help you on this:
forum.appian.com/.../e-118813
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
siddharthg837
over 9 years ago
One of the approach to cater this is to change the timezone value prior to storing in database for which you can use gmt() or local() functions. But store your datetime values in the database in GMT to avoid this sort of problems. Please go through time zone context, date and time functions to understand in detail.
forum.appian.com/.../Time_Zone_Context
forum.appian.com/.../Date_and_Time_Functions
forum.appian.com/.../Date_and_Time_Functions
forum.appian.com/.../Data_Types
forum.appian.com/.../Date_and_Time_Functions
The similar post around this which might help you on this:
forum.appian.com/.../e-118813
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data