msdb.dbo.agent_datetime

msdb.dbo.agent_datetime is translate from integer data and time numbers (in YYYYMMDD and HHMMSS formats) to datetime.

select msdb.dbo.agent_datetime(20170205, 0)

select msdb.dbo.agent_datetime(20170205, 123122)

select msdb.dbo.agent_datetime(20170205, 112)

select run_date,run_time, msdb.dbo.agent_datetime(run_date,run_time)

from msdb.dbo.sysjobhistory