http://www.sqlservercentral.com/Content tagged T-SQL, msdb posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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.

]]>http://www.sqlservercentral.com/redirect/articles/66894/Wed, 20 May 2009 06:00:00 UThttp://www.sqlservercentral.com/redirect/articles/66894/