数字转成成日期格式

Question

sqlserver中的table中有这样的dateDownLoadTimeStamp字段，类型是float,值是39827.5920023148，我怎么把39827.5920023148转换成YYYY-MM-DD HH:MI:SS这样的格式呢？求指教，多谢

Answer 1

SELECT CAST(39827.5920023148 AS DATETIME)
--2009-01-16 14:12:28.997SELECT CAST(dateDownLoadTimeStamp AS DATETIME) FROM TB

Answer 2

select CONVERT(datetime,39827.5920023148,120)
select CONVERT(datetime,dateDownLoadTimeStamp,120) from tb

Answer 3

CREATE TABLE #temp(dateDownLoadTimeStamp DATETIME)
INSERT #temp SELECT 39827.5920023148SELECT CONVERT(VARCHAR(19), dateDownLoadTimeStamp, 120) FROM #temp