What's the date format?

Question

reverse engineering

There is a database in SQLite3 format that stores tables, some of which have date / time columns with very large numbers (I don’t know those :) here is an example, local time is known up to a minute 2018-10-05 14:21 and for it is this very timestamp 13183208474659875 in an unknown format. The task is to find out how to get something like 2018-10-05 14:21 or at least the more
familiar int32 unixtimestamp from this huge number 13183208474659875.

Answer 1

It's a Unix timestamp with microseconds, so:
PHP example:

date_default_timezone_set('Europe/Samara'); // UTC+4:00

echo date('d.m.Y H:i:s', 13183208475); // "05.10.2387 14:21:15