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