Welcome to the Tweaking4All community forums!
When participating, please keep the Forum Rules in mind!
Topics for particular software or systems: Start your topic link with the name of the application or system.
For example “MacOS X – Your question“, or “MS Word – Your Tip or Trick“.
Please note that switching to another language when reading a post will not bring you to the same post, in Dutch, as there is no translation for that post!
[Solved] SQLite - Convert Unix Time (Epoch or POSIX Time) to DateTime
(@hans)
Famed Member Admin
Joined: 11 years ago
Posts: 2796
Topic starter
October 11, 2018 1:29 AM
Working on "Rename My TV Series" I ran into a small issue; the TVDB API (v2) gave back a Unix Epoch formatted DateTime (also known as Unix Time or POSIX time), yet I wanted to store a DateTime in my SQLite database.
Finally found the trick:
datetime(UnixTime, 'unixepoch', 'localtime')
Here "UnixTime" is the actual Unix time number (Int64), so in a full query it would look like this:
INSERT INTO "tvshows" ("tvdbid","lastupdated") VALUES ("123", datetime(1531412877, 'unixepoch', 'localtime') );
Hope it's useful for someone