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.