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
Shrinivas,Run_Date is yyyymmdd in integer form.
Run_Time is hhmmss in 24 hour time.
Duration is seconds.
Hope this helps,
Eric
-- Anonymous, May 08, 2002
KOL AIRI
-- Anonymous, June 10, 2004