select dateadd(MILLISECOND, @ts % 1000, dateadd(SECOND, @ts / 1000, cast('1970-01-01' as datetime2(7))))