DateTime changes when passed from database to table expression
Application Type
Service Studio Version
11.11.8 (Build 45664)

Hi All,

I have an issue when DateTime values are passed from database to table expression. It gives the wrong time.

Table Expression Output:-

Database:- Tried filtering the aggregate for the same record and checked the Created On DateTime. It has capture has below.



Hi Vinod,

this is completely normal behaviour in reactive applications. 

The datetime in your database is stored in the server's timezone, for example ETC.  

The datetime automatically gets changed into the datetime of the user's timezone when retrieved and displayed on a reactive screen.


So you are probably testing this in a timezone that is 2,5 hours ahead of the server.


Dorine is right, here is an intresting article on the topic:

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.