Mendix Datetime UTC and Server time

0
I am trying to insert a object in external database(Microsoft SQL).  Process 1 : Using Query external database Activity. One of the attribute type is DateTime, I am parsing the CurrentDateTime. This action working as expected and i can see the object in database table with DateTime attribute contains my server time.        Process 2 : I am using Query external database Activity for retrieval from the database. while retrieving i am getting the DateTime as UTC time.
asked
1 answers
0

This is standard behavior. Mendix stores data as UTC and display as local time zone.

 

Do you want to see same database value ? In that case convert it into UTC format. 

 

The rule is : 

  • DB : always UTC

  • UI : user’s local time

  • Mendix auto-converts both ways

answered