from here:
SQLite
SELECT datetime(MyColumn, “unixepoch”, “localtime”) FROM MyTable
MySQL
SELECT from_unixtime(MyColumn) FROM MyTable
from here:
SQLite
SELECT datetime(MyColumn, “unixepoch”, “localtime”) FROM MyTable
MySQL
SELECT from_unixtime(MyColumn) FROM MyTable