Skip to main content
6-Contributor
April 27, 2023
Solved

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.

 

 

 

Best answer by Sathishkumar_C

All DATETIME values will be automatically converted from server time to browser time on the client side (Thingworx). 

 

Please refer following articls/posts,

1 reply

17-Peridot
April 28, 2023

All DATETIME values will be automatically converted from server time to browser time on the client side (Thingworx). 

 

Please refer following articls/posts,

6-Contributor
May 2, 2023

The server and the browser on the client side was in the same datetime, so I had to restart tomcat service, to see the datetime values correctly.