Try thisDECLARE @Sample TABLE ( f CHAR(5), lastmod CHAR(16), filedate DATETIME )INSERT @SampleVALUES ('File1', '0d4081fc676aac10', '2/5/2010 10:20'), ('File2', '0c03f1fc676aac10', '2/5/2010 10:20'), ('File3', '0c18164bf2f7ac10', '12/17/2009 10:43'), ('File4', '0bbe32fc676aac10', '2/5/2010 10:20'), ('File5', '0a6a82fc676aac10', '2/5/2010 10:20'), ('File6', '46bd5b9873db9c10', '4/14/2009 14:30'), ('File7', '0a88d2fc676aac10', '2/5/2010 10:20');WITH cteYakAS ( SELECT f, filedate, CAST('' AS XML).value('xs:hexBinary(sql:column("Yak"))', 'BINARY(8)') AS Bin FROM ( SELECT f, filedate, REVERSE(lastmod) AS Yak FROM @Sample ) AS d)SELECT f, filedate, CAST(DATEADD(SECOND, Sec, DATEADD(MINUTE, Peso, 0)) AS DATETIME2(0)) AS PesoFROM ( SELECT f, filedate, CAST((CAST(Bin AS BIGINT) - CAST(94354848000000000.0 AS BIGINT)) / 10000000 / 60 AS INT) AS Peso, CAST((CAST(Bin AS BIGINT) - CAST(94354848000000000.0 AS BIGINT)) / 10000000 % 60 AS INT) AS Sec FROM cteYak ) AS d
N 56°04'39.26"E 12°55'05.63"