title: How to convert 3/4 Character Integer to 24 Hour Time Format and combine with date ?
body: <p>I have a doc Column of Date Time format, but it always leaves the time blank, and I have a time field which is an integer which represents hours and minutes (not including seconds). I would like to convert the time and add it to the date so that I can select <code>Max(datetime)</code> and return a single value. </p>
  
  <p>Here is my <a href="http://sqlfiddle.com/#!3/8e22e" rel="nofollow">SQL Fiddle</a>.</p>
  
  <p>The Data is stored as follows:</p>
  
  <pre><code>DocDate                 DocTime
  2013-04-29 00:00:00.000 1416
  2013-04-29 00:00:00.000 1027
  2013-04-29 00:00:00.000 823
  </code></pre>
  
  <p>I'd like to convert it to:</p>
  
  <pre><code>DateTime
  2013-04-29 14:16:00.000 
  2013-04-29 10:27:00.000 
  2013-04-29 08:23:00.000 
  </code></pre>