MediaMonkey forum

In the SQLite3 db for MM4, all the fields that contain dates do not seem to follow Unix or epoch time format. For example, using this converter link, it will not correctly convert dates shown in the MM.DB, such as:

40020.7278236459

The unix/epoch time format is 10 digits. I canot figure out how to convert this to a human-readable date.

When I enter the result is: , and when I enter the result is I want to access this info directly (not generate a report through the MM GUI).

We have no method to converting that, but it's simple:

PetrCBR wrote:We have no method to converting that, but it's simple:

Code: Select all

SQL time to UNIX:
trunc((SQLTime - 25569) * 86400);

UNIX to SQL time:
(UnixTime / 86400) + 25569;

Perfect! thanks so much.