Timestamp With 9 Digits In Sqlite File

I am working on a SQLite file from a client and found a column marked as TIMESTAMP, I have work in the past with php timestamp with 10 digits, this file has time stamps with 9 digi

Solution 1:

I'd guess it's an Apple Core Data timestamp, based on this:

sqlite> selectdatetime(570822838.260406, 'unixepoch', '+31 years');
2019-02-0217:53:58

So you can use the above to convert to a standard format.

(Also, check out this answer .)