DateTime changes when passed from database to table expression
Question
Application Type
Reactive
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.


Regards,

Vinod


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.

Dorine

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

mvp_badge
MVP

Dorine is right, here is an intresting article on the topic: https://itnext.io/outsystems-date-time-handling-a2d6e57eff8d


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