字符串格式错误.它应该是 09:47:11.895799.您需要将最后的 : 替换为 .

The string is in the wrong format. It should be 09:47:11.895799. You need to replace the final : with a .

SELECT CAST(STUFF('09:47:11:895799', 9,1,'.') AS TIME)