Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags T-SQL, msdb Rss

   Items 1 to 1 of 1   
 

SQL Server user defined function to convert MSDB integer value to time value

In a recent tip I outlined a process for converting a date, stored as an integer into a datetime data type. Date and time information for run history of SQL Server Agent jobs is stored within the msdb..sysjobshistory table as an integer data type, not as a datetime as one would expect. As promised, this tip picks up where we left off. On converting the integer-typed run_time into a format that is more user friendly for presentation purposes.  Read more...
By Additional Articles 2009/05/20 | Source: MSSQLTips.com | Category: msdb
Rating: (not yet rated)  Rate this |   Briefcase | 2,016 reads
   Items 1 to 1 of 1