I am using Thingworx 8.4 with Postgres database, Analytics extension and Kepserverex. Thingworx and Kepserverex servers are configured to Timezone CET.
In the following examples the current time is ~1210(German Standard CET):
(1) I execute the queryPropertyHistory service with a Thing receiving data(current) from Kepserver, with the following results:
The time is exactly 3h off.
(2) Now I execute the following code as a service of the same thing:
var dateValue = new Date();
var formattedDate = dateFormat(dateValue,'yyyy-MM-dd hh:mm zzz');
var result = formattedDate; //resulttype string
The Time is UTC so 1h off.
(3) Now I execute this code as service:
result = new Date(); //result datatype: DATETIME
The time is 2h off.
When I try to display the data in a Time Series chart in a mashup using QueryPropertyHistory, the time is 1h off.
The first (1) example changes the difference of time sometimes.
Also: I checked with different things, but got the same result.
What is the reason for this?
Solved! Go to Solution.