KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Could you help me convert UNIX epoch time into format yyyy-mm-dd hh:mm:ss (24h) in SQLite? (GMT+7 would be appreciated). Example: from 1319017136629 to Wednesday, October 19, 2011 4:38:56 PM GMT+7 . p/s: Just looked around and found a solution: SELECT datetime(1319017136629, 'unixepoch', 'localtime'); But i am still looking for a way to batch convert UNIX epoch time in SQLite.
Tags (comma-separated)
Save Edits
Cancel