The sysjobhistory table in the MSDB database has several columns that are INT datatype that are used to store date based values. The columns are specifically
As SQL Server now has DATE and TIME data types the values in these columns would be more readily usable if their data types changed to DATE, TIME and TIME respectively. Aggregation and calculation using functions such as SUM, AVERAGE, DATEADD, DATEPART, DATEDIFF would be applicable to the column value without any prior CAST/CONVERT or 'shredding' operations to split the hours, minutes and seconds values out. Using an INT to store a time in the HHMMSS format makes problems when the data comes to be used.
This change would benefit SQL Server by reducing developer time required and unnecessary processing of the values to carry out calculations including but not limited to those described above.