run_duration
- From: Pete D <PeteD@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 13 Jun 2005 04:13:02 -0700
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.
.
- Prev by Date: Re: Reprocessing Question
- Next by Date: Truncate Statement
- Previous by thread: Reprocessing Question
- Next by thread: Truncate Statement
- Index(es):
Loading