title: SQL add Datetime add hour add Minute
body: <p>In my table I have <code>DateTime</code>, <code>Hour</code> column.</p>
  
  <p>example : <code>2012-05-14 00:00:00.000</code> and <code>1230</code></p>
  
  <p>How can I add this <code>hour</code> column into my <code>Datetime</code> column, so I can have</p>
  
  <pre><code>2012-05-14 12:30:00.000
  </code></pre>
  
  <p>I tried with this:</p>
  
  <pre><code>SELECT DATE_DEBUT, HEURE_DEBUT, 
     DATEADD(hour, CONVERT(int, SUBSTRING(HEURE_DEBUT, 0, 2)), DATE_DEBUT) AS DateTemp, 
     DATEADD(hour, CONVERT(int, SUBSTRING(HEURE_DEBUT, 2, 2)), DateTemp) AS DateComplete
  FROM ESPTEMPS_PROGRAMMATION
  </code></pre>
  
  <p>but it does not work.</p>
  
  <p>thanks you in advance,
  Stev</p>