SQL Server ->> MSDB.DBO.AGENT_DATETIME函数从整型转时间日期格式

SELECT MSDB.DBO.AGENT_DATETIME(20170101,0), CAST(CAST(20170101 AS NVARCHAR(50)) AS DATETIME)

返回

2017-01-01 00:00:00.000