Change of time

0
Hello, I have a problem with Mendix Studio Pro. The issue arises because I am working with my PostgreSQL database. Everything is fine there; I insert a field for the time, and it inserts without any problem and perfectly. To reference the database, I am using the 'ExternalDatabaseConnector.' When I put the query there and run it, it works without any issues and returns the correct time. However, when I click on 'Run Locally,' it shows the time with an additional two hours, and everything is set to my timezone Europe/Madrid.
asked
2 answers
0

Do note that Mendix stores all dates in its own database in UTC. See also this FAQ: https://docs.mendix.com/refguide/datetime-handling-faq/

So when retrieving Date time objects from external databases and you store those in your local Mendix database it all depends on the conversion you have done receiving that data.

 

Regards,

Ronald

 

answered
0

ok, I already have that solved, thanks

answered