title: Converting to DATETIME from separate date and time fields
body: <p>I have a MYSQL database in my company's workplace and the timestamps are often stored like this:</p>
  
  <pre><code>ModDate  |  ModTime  |  Other fields
  ------------------------------
  20110405 |  203055   |  .....
  20110506 |  214016   |  .....
  </code></pre>
  
  <p>I'm sure there was probably a valid reason for doing it at the time (developers have left), but we now mainly use SQL Server.</p>
  
  <p>I've written a query to turn the <code>ModDate</code> field into standard <code>DATETIME</code>, but obviously I always get the time as <code>00:00:00</code>.</p>
  
  <p>How do I get a valid <code>DATETIME</code> object from SQL Server which combines the <code>ModTime</code> and  <code>ModDate</code> field so that I get a combined correct value?  Note, I've already extracted them into a local result set and I have no intention of changing the MYSQL database (I'm simply extracting from it with an <code>OPENQUERY</code>).</p>