#HawaiTimeZone

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]

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.