cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

ThingWorx display different time than DB had

JK_10565232
12-Amethyst

ThingWorx display different time than DB had

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

2 REPLIES 2
DanZ
15-Moonstone
(To:JK_10565232)

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.

JK_10565232
12-Amethyst
(To:DanZ)

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.

Announcements


Top Tags