I have the results of a system sproc that give me the date and time (as seperate fields) something ran.So I have the time last run as: 180001 I need to convert that to something more like 18:00:01 ...