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
DB time values are stored in UTC (essentially the same as GMT but some subtle differences do exist if you look it up); this is, AFAIK, fairly industry-standard, and should be assumed in your application design. Appian makes it trivially easy to convert stored time values back to the local timezone (or a hardcoded one) if/when needed. I'd estimate that very very few use cases are enough of an emergency that they'd warrant hardcoding the DB to store EST times.
Can you provide more details as far as the issue you're running into? Are these searches/bots retrieving DB data in some unusual way? AFAIK datetime-based query values from Appian will autoconvert their values such that you'd get expected results. Sometimes filtering on datetime fields when feeding in only a date value would need a (pretty simple, tbh) conversion to get the "date boundaries" exactly right in the query result - but I know of no cases where this requires the DB to be in EST, nor any where such conversion would actually make anything easier in the long run.