UTC versus non-UTC

0
I noticed that a few of my records have a datetime that shifted for 1 hour during daylight time shift a few weeks ago. How to avoid this: have everything in UTC. Is there a plan available to transform a complete application from non-UTC to UTC?
asked
1 answers
1

It depends heavily on the sort of date time objects. As a rule of thumb we always use non localize date time objects on things like birthday where time is not an issue. The only why to get this right is to make the attribute non localize and use a microflow to adjust all the dates . It is wise to first download your database and check with pgadmin your data. It gives you a good feel on how the hotfix microflow should look like.

The result should be that all the non-localized dates in the database should have an UTC time of 00:00.

Good luck,

Ronald

answered