whats the impact of converting GMT to EST Timezone in Database?

Certified Associate Developer

Currently, we have the database time set as GMT which is four hours away from the Eastern time zone. We are running into issues with Time based search and bots processing of cases for a certain day since the server time is different.


1. Is it possible to update database tiezone to EST?
2. If we updated to EST what will be the impact of Existing application?

  Discussion posts and replies are publicly visible

Parents
  • We use Oracle's FROM_TZ in a database view for troubleshooting (the view has both Appian's original UTC timestamps and generated local timestamps). This helps humans troubleshoot status/history tables from the database. I can see how using CONVERT_TZ for a similar use case in MariaDB could be helpful (especially if you prefer using named zones instead of offsets).

Reply
  • We use Oracle's FROM_TZ in a database view for troubleshooting (the view has both Appian's original UTC timestamps and generated local timestamps). This helps humans troubleshoot status/history tables from the database. I can see how using CONVERT_TZ for a similar use case in MariaDB could be helpful (especially if you prefer using named zones instead of offsets).

Children
No Data