I've inherited an undocumented MS Access database where the date/time values are stored in an
INT column and the majority of values I've seen so far are 10-digit negative integers.
How do you process these as if they were
DATETIME in SQL queries?
If it simply can't be done through SQL and must instead be done through a programming/scripting language, what maths/process is required to transform these values into human-readable dates and times?
The data was captured during the period 2006-2019 so the timestamps will be within that time frame.