Hi,

Some of the values are also 14 digit . If I use your code below , it returns incorrect dates as shown below.

declare @TimeMS bigint = 61353491400000;

select

[Date/Time] =

-- Verify time can be converted to datetime

case when @TimeMS between -6847804800001 and 253402300799998

then dateadd(ms,@TimeMS%86400000,(@TimeMS/86400000)+25567)

else null end

--INCORRECT RESULT

Date/Time

3914-03-20 20:30:00.000