How to convert Unix era in SQLite

SELECT datetime(1319017136629,'unixepoch','localtime');

UPDATE MyTable SET MyColumn = datetime(MyColumn,'unixepoch','localtime')

You can help me convert the unix era to The format yyyy-mm-dd hh:mm:ss(24h) is in sqlite? (GMT 7 is very appreciated).

For example: from 1319017136629 to 4:38:56 PM GMT 7 on Wednesday, October 19, 2011

Thanks in advance.

p/s: Look around to find a solution:

SELECT datetime(1319017136629,'unixepoch','localtime');

But I am still looking for a way to batch convert Unix epoch times in SQLite.

To change the value in the database, use the UPDATE command:

UPDATE MyTable SET MyColumn = datetime(MyColumn,'unixepoch','localtime')