Knowledgebase
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.
Need further help getting started?
You did not find what you were looking for? Please contact us so we can provide an answer to your question.
Contact Form