[quote="PetrCBR"]We have no method to converting that, but it's simple:
[code]SQL time to UNIX:
trunc((SQLTime - 25569) * 86400);

UNIX to SQL time:
(UnixTime / 86400) + 25569;
[/code][/quote]

Perfect! thanks so much.

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

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

We have no method to converting that, but it's simple:
[code]SQL time to UNIX:
trunc((SQLTime - 25569) * 86400);

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

7278236459

8/21/2200, 3:20:59 PM

40020.7278236459

1/1/1970, 5:07:00 AM

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 [url=https://www.freeformatter.com/epoch-timestamp-to-date-converter.html]converter link[/url], 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 [code]7278236459[/code] the result is: [code]8/21/2200, 3:20:59 PM[/code], and when I enter [code]40020.7278236459[/code] the result is [code]1/1/1970, 5:07:00 AM[/code]

I want to access this info directly (not generate a report through the MM GUI).