Hello everyone.
I am having the following problem: I created a record on 2021-03-01 23:53:05 but in the database the “create_date” field is stored with the date 2021-03-02 04:53:05. The same offset happens when I modify a record (“write_date” field). Why is this happening?
Postscript: my OS is configured with the UTC -05 timezone (Guayaquil, Ecuador) and the database shows the “America / Guayaquil” timezone. In Tryton, my company’s Time Zone is set to “America / Guayaquil”.
This is the expected behaviour because Tryton stores datetimes using UTC timezone on server side.
Then the clients display the date using the user Timezone. If you check on the tryton client you will see that the date is correctly shown.
Even for reports we have a format_datetime function which converts the datetime to a timezone.
This feature allows to always show the correct time on all of the timezones and makes the system usable for users of different timezones in the same database.