#HawaiTimeZone

Appian Cloud databases are all set to use EST. if you have an Appian process writing to the database from a different timezone, you'll need to ensure the process model and user locale's are set accordingly. If you have the database generating the date/datetime via a stored procedure, etc, you'll need to have the correct locale applied manually.

Hey Thanks coltonb User Locales are nothing but User Properties ? and You are suggesting to write a stored procedure to write the date correctly Am i right?

No, I'm only suggesting that if you're already using stored procedures to write the datetimes and they're showing incorrectly.

If you're not using stored procedures or database functions, ensure your process model and specific user timezone is set correctly. PM timezones can be controlled in the process model properties and users' timezones can be set by selecting the username in the top right corner of the runtime designer interface.

You can also test this by running now() in the expression editor to see what is returned.

Which DB are you using? Are you in the Cloud? Let me tell you some notes on this.

1) From Appian documentation ”The database can be set to any time zone as long as the datetime values persisted from Appian are always returned as the same value when retrieved by Appian. Appian stores and retrieves datetime values as if they are set in the GMT time zone”

2) Be careful when creating columns inthe DB.
For example from Oracle Documentation “The following datetime format elements can be used in timestamp and interval format models, but not in the original DATE format model: FF, TZD, TZH, TZM, and TZR.”
From My SQL: You have to make certaing configurations. ( refer to the link)

3) I guess you are using the now inside an Interface Rule?

With all this said:
- take a look how this is getting stored in the DB, is there any difference in the time you store?
- you are just saving the Date or Date and time?



References

“Configuring Relational Database”, 2017. Appian Corporation. Available at [https://docs.appian.com/suite/help/17.2/Configuring_Relational_Databases.html]

“Datetime Format Elements”, 2017. Oracle Corporation. Available at [ https://docs.oracle.com/cd/B28359_01/server.111/b28286/sql_elements004.htm#SQLRF00211]

"MySQL Server Time Zone Support", Oracle Corporation. Available at [https://dev.mysql.com/doc/refman/5.5/en/time-zone-support.html]

Hi josep,

We are Using MYSQL which is on the Appian Cloud.
Yes we are Using Appian Cloud

We are saving the Date and Time
there is difference in the time i store.