run_duration



Microsoft SQL Server 2000
I'm looking at a run_duration value in table sysjobhistory in database msdb
which is an int value 24304 I understand this equates to 2 hours 43 mins and
04 seconds. I would like to put a select statement around 24304 to make it
appear more readable e.g. 2:43:04
I would like to do this without having to convert it to string and breaking
it down to it's various components. Is there a function I can use which
would allow me to do this?
Thanks.

.


Loading