sqlserver的float数字如何转成成日期格式
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