Bug: Date edits revert to 1969-12-31 (+/- a day depending on time zone)

[Volts]

Another report of the same issue:

Manually changing "Originally Available" date, Plex changes it to 1970-01-01

I agree, I think there’s a bug in either PMS or the Web UI.

Plex has recently changed how datetime values are stored in the database, and is now using unix-style epoch seconds. But the Web UI is still sending YYYY-MM-DD values, which aren’t being converted.

Can no longer update library database with sqlite3

@ourcore, there are lots of examples above! What have you tried? What platform are you using? Note to others - Plex 1.26.x has changed the datatype of datetime columns. Plex is now storing a unix-style seconds-since-1970-epoch time. Here’s a web toy for converting this format: https://www.epochconverter.com/ The sqlite strftime() function can be used in UPDATE statements to convert to epoch seconds on the fly; modify the YYYY-MM-DD and ABC as you would have before. UPDATE metadata_items SET…