The time zone is not working correctly for me.

0
Hello,I’m having an issue when working with the time zone. The problem is the following: I’m from Spain, where my time zone is GMT +01:00. The problem arises because I have a Date Picker in which I select the day to insert it into a PostgreSQL database. So, if from Mendix I insert the date of January 1st, 2025, it inserts December 31st at 23:00 in the database, subtracting 1 hour. The same thing happens in summer: if I insert July 1st, 2024, it inserts June 30th at 22:00 due to daylight saving time, showing two hours less. My database is also set to Madrid/Europe time zone. How can I solve this? Best regards and thanks.
asked
1 answers
0

Hi,

Time is always stored in UTC in mendix database and also for all operations , it is just converted to user's timezone and shown in UI , if you have set localize as yes in your domain model.

 

answered