How to convert integer value to time : 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

Moderation questions? read the FAQ