Page 1 of 1

SQLite – Convert Unix Time (Epoch or POSIX Time) to DateTime

SQLite – Convert Unix Time (Epoch or POSIX Time) to DateTime

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.
Examples: "MacOS X - Your question", "MS Word - Your Tip or Trick".

Please note that switching to another language when reading a post will not work!
Posts will not have a translated counterpart.




RSS Feed

Home Forums Software Development Databases SQLite – Convert Unix Time (Epoch or POSIX Time) to DateTime

This topic contains 0 replies, has 1 voice, and was last updated by  hans 1 month ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • 10988

    hans
    Keymaster

    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 

Viewing 1 post (of 1 total)



You must be logged in to reply to this topic.