Page 1 of 1

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!

SQLite - Convert Un...
Clear all

[Solved] SQLite - Convert Unix Time (Epoch or POSIX Time) to DateTime

1 Posts
1 Users
Famed Member Admin
Joined: 11 years ago
Posts: 2677
Topic starter  

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