Skip to main content
S
swapnac559884
November 10, 2024
Question

Datetime stored in UTC in EDT will show different date in EST

  • November 10, 2024
  • 3 replies
  • 0 views

We are running a process based on given exact Date Time which is stored in UTC entered by the user in the UI with schedulers. Lets take example the scheduler planned to run at 11/10/2024 12:00 AM,  and its stored in DB as 11/10/2024 -4:00 UTC. When time zone change from EDT to EST its coming as 11/09/2024 11:00 PM which kicks the process 1 hour before which is not expected. I'm wondering so all the dates entered or captured in DB during EDT will be shown in Appian as  Actual time - 1 hour. Isn't this unusual?

3 replies

kumara0180
kumara0180
November 11, 2024

All the time which get stored in DB are in GMT. You would need to consider that while bringing the values back from DB. 

Personally I also have struggles with how time keep changing due to timezones and DB 

stefanhelzle0001
stefanhelzle0001
November 11, 2024

Maybe my blog post helps a bit: https://appian.rocks/2023/02/13/working-with-time-in-appian/

sarathkumr268295
sarathkumr268295
November 12, 2024

The time values are always stored as GMT in database. Based on user timezone, the time gets converted automatically while being displayed on the UI. So its the user's timezone which decides how the time looks in the front end and not the value in the database. 

Terms & ConditionsAccessibility statement