I tried the epoch converter and did not get anywhere. Here is a screenshot from my sqlite file. The following timestamp from the sqllite file 131923064483430000 is in nano seconds. Dividing by a million gives 131923064483 seconds. Using the epocj website the timestamp is
GMT: Thursday, March 7, 1974 9:17:44.483 PM
Your time zone: Thursday, March 7, 1974 5:17:44.483 PM GMT-04:00
Relative: 45 years ago
BUT if I view the History table on the HMI then it shows correct data.
So no, it's not just a timestamp and the epoch converter is unable to convert it.
Any other ideas what this could be?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello CoDeSys Crowd,
i would like to know wich data format of the TS Column in TBlTrendData.
How to change the Format into something human readable?
The attached Screenshot is done with DB Browser for SQLite.
TS - it is time stamp number of second from Thu, 01 Jan 1970 00:00:00 GMT (can check here https://www.epochconverter.com/)
I tried the epoch converter and did not get anywhere. Here is a screenshot from my sqlite file. The following timestamp from the sqllite file 131923064483430000 is in nano seconds. Dividing by a million gives 131923064483 seconds. Using the epocj website the timestamp is
GMT: Thursday, March 7, 1974 9:17:44.483 PM
Your time zone: Thursday, March 7, 1974 5:17:44.483 PM GMT-04:00
Relative: 45 years ago
BUT if I view the History table on the HMI then it shows correct data.
So no, it's not just a timestamp and the epoch converter is unable to convert it.
Any other ideas what this could be?
It's LDAP format:
https://www.epochconverter.com/ldap m