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

Community Tip - Want the oppurtunity to discuss enhancements to PTC products? Join a working group! X

What is a relationship between OPC DA client's timestamp and PostgresSQL "time" field?

Michail
9-Granite

What is a relationship between OPC DA client's timestamp and PostgresSQL "time" field?

Hi there, I'd like to understand the difference between the timestamp of the property data-change event acquired by the OPC DA client and the "time" (timestamp without timezone) field of the value stream.

To illustrate, consider the following scenario. Machine is running with the OPC DA client installed (version 5.7). A property has changed its value at 09:20 am. Corresponding timestamp would look something like: "2017-08-18 09:20:00". The database has registered this event, however, the timestamp is different - "2017-08-18 10:20:00" (1h ahead).

Having read the following article and documentation​ I assumed that the timestamp sent by the OPC DA client must be of the following type:"2017-08-18 09:20:00Z" (GMT timezone). Since there is no time difference between UTC and GMT, PostgresSQL would store this timestamp internally. Whenever the property value is queried, the timestamp will be converted to the appropriate timezone (as set in "postgresql.conf"). Since my PostgresSQL is set to be "Europe/London", the timestamp is therefore: "2017-08-18 10:20:00".


Is the above observation true? Thanks.


0 REPLIES 0
Top Tags