Transform FILETIME to human readable string in SQLite request
And the magic formula is:
select datetime( (YourTimeColumnName - 116444736000000000)/10000000, 'unixepoch') from YourTableName
It took for me quite some time to create this expression, since I’m pretty dumb in SQL.
But it seems to work, and probably someone will need it, so its posted!
If YourTimeColumnName is in string format, cast function must be used.
Categorised as: Uncategorized