How to convert integer value to timegreenspun.com : LUSENET : SQL Server Database Administration : One Thread
I am executing query on msdb database on sysjobhistory table . This table contains field called run_time with ineger data type . I want this value to be converted into time .
I want to know Job name , Its start time , end time , total run time .
How can I achive this ?
Please let me know
-- Anonymous, May 07, 2002
Run_Date is yyyymmdd in integer form.
Run_Time is hhmmss in 24 hour time.
Duration is seconds.
Hope this helps,
-- Anonymous, May 08, 2002
-- Anonymous, June 10, 2004