Posted Thu, 05 Dec 2019 07:44:43 GMT by Image Technologies
- MS SQL
- DW 7.1
In FileCabinet_SEC table there is a CONTENTMODDATETIME how to convert it to regular datetime 
Posted Thu, 05 Dec 2019 17:10:22 GMT by Josef Zayats
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

You must be signed in to post in this forum.