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

Sie müssen angemeldet sein um Beiträge in den Foren zu erstellen.