https://forge.codesys.com/forge/talk/Engineering/thread/6079350680/2020-02-27T13:56:11.224000ZRecent posts to Trend Timestamp Format sqlite2020-02-27T13:56:11.224000Z2020-02-27T13:56:11.224000Ze.kislovhttps://forge.codesys.com/u/e-kislov/https://forge.codesys.com5bb62b5d8aef80d695c58223eed7fde3cc2b0fa0

<div class="markdown_content"><p>It's LDAP format:<br/> <a class="" href="https://www.epochconverter.com/ldap" rel="nofollow">https://www.epochconverter.com/ldap</a> m </p></div>

2020-02-27T13:56:11.017000Z2020-02-27T13:56:11.017000Zmandeepahujahttps://forge.codesys.com/u/mandeepahuja/https://forge.codesys.combc4ee0038f6465a679d07b0fb44369fcea9db9d1

<div class="markdown_content"><p>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 </p> <p>GMT: Thursday, March 7, 1974 9:17:44.483 PM<br/> Your time zone: Thursday, March 7, 1974 5:17:44.483 PM GMT-04:00<br/> Relative: 45 years ago</p> <p>BUT if I view the History table on the HMI then it shows correct data. </p> <p>So no, it's not just a timestamp and the epoch converter is unable to convert it.</p> <p>Any other ideas what this could be?</p> <p><img alt="IMG: Application.alarmstorage.sqlit.png" rel="nofollow" src="https://forum.codesys.com//download/file.php?id=4431"/></p></div>

2020-02-27T13:56:10.820000Z2020-02-27T13:56:10.820000Zmurdemonhttps://forge.codesys.com/u/murdemon/https://forge.codesys.com157fd74a202cf6beae675cc74f16056395a8446b

<div class="markdown_content"><p>TS - it is time stamp number of second from Thu, 01 Jan 1970 00:00:00 GMT (can check here <a class="" href="https://www.epochconverter.com/" rel="nofollow">https://www.epochconverter.com/</a>)</p></div>

2020-02-27T13:56:10.184000Z2020-02-27T13:56:10.184000ZAndi@Turckhttps://forge.codesys.com/u/andi-turck/https://forge.codesys.com3d0a70d66fd1457226a0489e42a2481af9bccbe1

<div class="markdown_content"><p>Hello CoDeSys Crowd,<br/> i would like to know wich data format of the TS Column in TBlTrendData.</p> <p>How to change the Format into something human readable?</p> <p>The attached Screenshot is done with DB Browser for SQLite.</p> <p><img alt="IMG: 2017" rel="nofollow" src="https://forum.codesys.com//download/file.php?id=2613"/></p></div>