https://forge.codesys.com/forge/talk/Engineering/thread/d1454f74cf/2020-03-28T13:54:28.591000ZRecent posts to How to read a sqlite log database? alarmlog or AC_DataLog2020-03-28T13:54:28.591000Z2020-03-28T13:54:28.591000ZDavidBohttps://forge.codesys.com/u/davidbo/https://forge.codesys.com76e212c58afc5436ea6a9a117e1a87e1c4d5a08f

<div class="markdown_content"><p>The timestamp used for alarm log is this:<br/> <a href="https://www.epochconverter.com/ldap" rel="nofollow">https://www.epochconverter.com/ldap</a><br/> But I dont know how to convert it using sqlite3. It make it diffecult to do a query</p></div>

2020-03-28T08:50:14.988000Z2020-03-28T08:50:14.988000Zaliazzzhttps://forge.codesys.com/u/aliazzz/https://forge.codesys.come5fd4282bbd072018e0dfce739253deb96c77ec6

<div class="markdown_content"><p>Hi, </p> <p>Just want to add my two cents. <br/> I think reading back stored values from the AC_DataLog would be great!</p> <p>Aliazzz</p></div>

2020-03-28T08:41:06.004000Z2020-03-28T08:41:06.004000ZDavidBohttps://forge.codesys.com/u/davidbo/https://forge.codesys.com7e4c71a131c75ff04e86696dc370c9c7f88c3b93

<div class="markdown_content"><p>I can read the alarmlog with sqlite3, but I don't understand the format and the meaning of the various tables. However, I think that the time is specified in milliseconds since January 1984.<br/> How can I make query which list the alarms formatted correctly?<br/> I assume I have a similar problem with AC_DataLog . It is of course fine that we can store values in a sqlite database, but it would be nice if we also could read these stored values.</p></div>