Home Forums SQL Server 2012 SQL 2012 - General Adding YYYYMMDD and HHMMSS to get mm/dd/yyyy HH:MM:SS RE: Adding YYYYMMDD and HHMMSS to get mm/dd/yyyy HH:MM:SS
Lynn Pettis
SSC Guru
Points: 442467
More actions
June 12, 2014 at 3:45 pm
#1721264
How about this (sorry, but I didn't work with your query):
select
*,
cast(cast(run_date as varchar) + ' ' + stuff(stuff(right('000000' + cast(run_time as varchar),6),5,0,':'),3,0,':') as datetime)
from
msdb.dbo.sysjobhistory;