datetime Sqlite

 select datetime(columnDate/10000000 - 62135596800, 'unixepoch') from tabla ;