数字转成成日期格式
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
