How to convert datetimes in SQLite export
Question / Problem
How do I convert floating point time values to datetime in an exported SQLite database?
Answer / Solution
The date times represent days since the 12/30/1899.
You can access the date value in SQLite using the following method:
SELECT date(julianday('1899-12-30') + CREATION_TIME) AS CREATION_DATE FROM FILES
If you want to only get the time, use the method time(julianday('1899-12-30') + CREATION_TIME) or the method datetime(julianday('1899-12-30') + CREATION_TIME) to get date and time.