samedi 20 février 2016

How should I convert this seemingly invalid sqlite3 timestamp

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