CREATE TABLE filemeta (filemeta_id INTEGER PRIMARY KEY, localLastModified DATETIME)

select datetime(localLastModified,"YYYY-MM-DD HH:MM:SS") AS localLastModified from filemeta
select datetime(localLastModified) from filemeta

select localLastModified from filemeta