Skip to main content
swapnar6405
swapnar6405
May 26, 2023
Question

Date values different between process model and database

  • May 26, 2023
  • 7 replies
  • 0 views

Hi,

My current system date and time is 5/25/2023 9:03 PM and also, I am passing now() to one of the pv variables (Image#1). 

Image#1

But, when I try to see the db saved value, it was showing as "5/26/2023 01:03:40". 

Can someone advise me, where it was going wrong.

Thanks in advance.

7 replies

mathieud0001
mathieud0001
Brainy
May 26, 2023

Date and times stored in the db are in UTC. now() is displayed in your local timezone.

swapnar6405
swapnar6405Author
May 26, 2023

Thanks for replying for my post.
I have to keep values in EST. Is there any way, I can keep both values same.

mathieud0001
mathieud0001
Brainy
May 26, 2023

Not sure if I'm understanding correctly. You want your database dates to be stored in EST?

Storing dates in UTC and then displaying them in the user context timezone is the standard way of doing things (not just in Appian but in most systems).

Terms & ConditionsAccessibility statement