title: How to convert an integer (time) to HH:MM:SS::00 in SQL Server 2008?
body: <p>Here I have a table with a <code>time</code> column (datatype is <code>integer</code>), now I need to convert the integer value to time format <code>HH:MM:SS:00</code> in SQL Server 2008.</p>
  
  <p>Also need clarification in the above <code>time</code> format, whether 00 represents milliseconds?  </p>
  
  <p>Please help on this.</p>
  
  <p>example: 23421155 represents 23:42:11:55; 421151 represents 00:42:11:51</p>
  
  <p>Hope that it is clear now.</p>