hi Is it possible to avoid date conversion (to GMT) during saving t

Siby over 10 years ago

hi
Is it possible to avoid date conversion (to GMT) during saving to database (write to data store). I am trying to save the date based on the primary timezone specified at the "System" tab.

Regards
Stephen...

Discussion posts and replies are publicly visible

0 Brett Shomaker
Appian Employee
over 10 years ago

Dates in Appian do not have time zones. They are calendar dates.

The date and time data type does have a time zone, but the value is always stored in Appian in its GMT equivalent.

If you want to shift the value to a different time zone before storing it externally, you can use the gmt() or local() functions. However, consider storing your datetime values in the external database in GMT as well to avoid the hassle of conversion on retrieval as well.

forum.appian.com/.../Data_Types
forum.appian.com/.../Data_Types
forum.appian.com/.../Date_and_Time_Functions
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel