title: Converting a 5 digit int into time
body: <p>In a legacy system (SQL Server 2005)  I have a column that stores a 5 digit integer (ie 86340) as time. The legacy application shows 86340 as 23:59:00. I am unsure how how to translate that 5 digit integer into a date-time data type using SQL.  </p>