Skip to main content
J
JK_1056523212-Amethyst
12-Amethyst
April 26, 2024
Question

ThingWorx display different time than DB had

  • April 26, 2024
  • 1 reply
  • 911 views

Hello all TWX masters.

 

I installed TWX  9.3.6-b1323 from installer  and I have strange behaviors with time.

 

I have some records in MSSQL DB with time 14:05:56 but when I execute it from TWX side I have 16:05:56...

 

I checked server time - its ok

I checked DB time - its ok

I execute TWX service like getDate() - its ok

I checked Tomcat JVM setting (-Duser.timezone=UTC) so its ok...

I have empty mind where it could be a problem...

 

Best regards,

Jan

1 reply

D
DanZ15-Moonstone
15-Moonstone
April 26, 2024

All datetime objects displayed in Thingworx (Composer or Runtime) are converted to your browser's time. If you want to see the "raw" time, convert the datetime object to a string and let the service display it. Another way would be to log it in the ScriptLog.

J
JK_1056523212-AmethystAuthor
12-Amethyst
April 26, 2024

Hi,

You know it happen when I execute SQL Query from Connectors. It only happen there. I mean when I ask about DB data. 
All Date on datepickers ect works as it should.

 

I have two env on one single browser with TWX 8.4 - works perfect. With 9.3 works with 2 hours delay.

    Terms & ConditionsCookie settingsAccessibility statement