The new DayOne v2 app exports data as a sqlite3 database instead of a directory structure in v1.
In the new database there is a table called ZENTRY
with several columns. One column in the entry creation date named ZCREATIONDATE
.
I want to be able to convert the current timestamp to unixepoch OR UTC however both fail completely.
Here the some sample output of SELECT ZCREATIONDATE FROM ZENTRY;
431825796
431883335
431995404
432260498
At first I thought they were unixepoch times, but they are all 30 years off.
How should I go about correctly formatting these timestamps? I have attempted all seemingly combination of string formats from the sqlite Date/Time documentation: http://ift.tt/11EE2rC
Aucun commentaire:
Enregistrer un commentaire