MS SQL SEC table (CONTENTMODDATETIME column)

- MS SQL
- DW 7.1
In FileCabinet_SEC table there is a CONTENTMODDATETIME how to convert it to regular datetime 

Wrong forum for the question.
Here is a statement that will give you result with one minute precision. The number in the field is a number of tenth of microseconds since Jan 1st of year 0001.
If you need more precision, you'd have to try to split the number in two parts and use multiple DATEADDs 
(I think your MSSQL needs to be at least 2008 to have datetime2 as available type)

select DATEADD (minute,CONTENTMODDATETIME/60/10000000,convert(datetime2,'0001-01-01')) from FileCabinet_SEC