SQL Server字符转换成日期时报错

Question

如下时数据内容：
ListPK csvFile FileCount UpdateTime EDart_Path
100007167 changes_13EX500224.csv 18239 44661.427315 \CDUVMeDART09\logs
100007168 changes_12EX500039.csv 18135 44661.174039 \CDUVMeDART09\logs
100007169 changes_14EX500260.csv 18083 44659.927153 \CDUVMeDART09\logs

我在将UpdateTime字段的44661.427315转换为时间日期时报错：
Conversion failed when converting date and/or time from character string.

我的SQL语句如下：

SELECT [ListPK]
,[csvFile]
,[FileCount]
,CONVERT(datetime,UpdateTime)
,[EDart_Path]
FROM [CDU_Molding_156Share].[dbo].[EDart_FileCount]

Answer 1

SELECT [ListPK]
,[csvFile]
,[FileCount]
,CONVERT(DATETIME,'1900-01-01')-2+UpdateTime
,[EDart_Path]
FROM [CDU_Molding_156Share].[dbo].[EDart_FileCount]