I have the results of a system sproc that give me the date and ... BR>So I have the time last run as: 180001 <BR><BR>I need to convert that to something more like 18:00:01 in TSQL.