Date time showing incorrectly

We have an issue in our production environment that does not exist in our lower environments.

We have a WebAPI that external systems send in auditing information including a date time stamp.  The information is then written to the DB.  The information is retrieved and displayed to the user in their localized time zone.  The issue is that the date time is wrong on display.

Our DB and Appian server have different time zones in PROD.  Is this an issue?  

  Discussion posts and replies are publicly visible

Parents Reply
  • So there is the rub apparently.  The DB is GMT, the Appian Server is CDT.  We cannot change the server (it sits in a hosting center).  We could change the DB, but that would likely mess with dates already in the DB?  I am just going to wrap the date in the DB with gmt() function when displaying to the user.

    Would like to see the appian documentation on DB needing to have the same timezone as the app server, otherwise you need to use gmt and local functions to get what you want.

Children
No Data