We have a couple Jabber users whose chat logs we need to review. The chats in question were from before we had centralized archiving in place, so we had to pull the .DB files from their local hard drives.
We have been able to extract the tables form the DB files using SQLite and can access the sender, receiver, and content information, but the one thing we can't directly interpret is the date. In the DB file, the date is formatted as a 16-character number string similar to this: "1458312409000000".
What format is that date, and/or how to we convert that to a human-readable date-time?
