#HawaiTimeZone

Question

I have an Issue where the date of an registration is approved today using Now Function we are saving today's date but it is Taking Tomorrows Date for the Hawai Users. 
 Can you please help me with this Issue. 
 We basically write 
 a!save(ri!date,now)

Colton Beck · Answer

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.

josep · Answer

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]