CREATE FUNCTION [dbo].[FromSystemTimeToDateTime] (@biFileTime BIGINT) RETURNS DATETIME AS BEGIN DECLARE @RET AS DATETIME DECLARE @MS AS BIGINT DECLARE @MIN AS INT DECLARE @DAY AS INT SET @MS = (@biFileTime - 94354848000000000)/10000 IF (@MS < 0) RETURN CAST(0 AS DATETIME) SET @MIN = CAST(@MS/60000 AS INT) SET @DAY = CAST(@MIN/1440 AS INT) SET @RET = DATEADD(ms,CAST(@MS%60000 AS INT), DATEADD(mi,CAST(@MIN%1440 AS INT), DATEADD(dd,@DAY,CAST(0 AS DATETIME)))) RETURN @RET END