Timezone problem between postgres and thingworx
- April 27, 2023
- 1 reply
- 1617 views
I'm having the next problem. I have some records about our daily production in the postgres database, it records de timestamp of the begining of production of each product and the end of production, but when I use the service in thingworx to connect it to my database and show the data in a grid, the time is with an hour less than in the data base.
For example, a product begun at 10 AM and ended at 11 AM, the record in the database is with these hours, 27/04/2023 10:00:00 and 27/04/2023 11:00:00, when I show these records in a thingworx mashup, it shows 27/04/2023 09:00:00 and 27/04/2023 10:00:00
Does anyone knows the reason? recently, in my country, the daylight saving has been canceled I don't know if maybe that's the reason and if it is, how can I fix it?
Thanks in advance.

