Unix timestamp


The Unix timestamp is nothing more than a serial counter of milliseconds since January 1st, 1970.
To convert this time stamp to a DATETIME2-value in SQL Server (and avoid integer overflow), this is all you need to do