SIM database date-time column conversion

[SmooshedFace76]

I'm trying to run custom SQL scripts on the Insight database. The date-time columns are not written as a readable format. Instead, everything is a random number.

These columns are the bigint datatype which doesn't allow conversion.

When running reports in SIM, there are obviously some program files somewhere that are converting the data to a recognized date format.

Has anyone been able to write a SQL query against this database and successfully convert the date/time?

[David Claypool]

This is pretty common in SQL databases and represents time elapsed since 1/1/1970. Google for SQL BIGINT DATE and you'll find a number of algorithms to use.