sqlserver中的table中有这样的dateDownLoadTimeStamp字段，类型是float,值是39827.5920023148，我怎么把39827.5920023148转换成YYYY-MM-DD HH:MI:SS这样的格式呢？求指教，多谢
------解决方案--------------------
SELECT CAST(39827.5920023148 AS DATETIME)
--2009-01-16 14:12:28.997
SELECT CAST(dateDownLoadTimeStamp AS DATETIME) FROM TB