title: How to concatenate DateParts in Sql Server
body: <p>I really need a help from Database ninjas.</p>
  
  <p>I have the following piece of code:</p>
  
  <pre><code>SELECT DATEPART(hh, BeginMinute) AS Intervalo, SUM(Qtde) AS Total
    FROM tr_CustomerCount
  WHERE BeginMinute &gt; '5/22/2013 00:00:00 AM' AND BeginMinute &lt; '6/22/2013 12:00:00 AM'
  GROUP BY DATEPART(hh, BeginMinute)
  </code></pre>
  
  <p>Actually it just returns the Hour (HH) but I wanna show the HOUR and MINUTE together separated by " : " such '12:00' its can be a String, no worries.</p>
  
  <p>How can I do this?</p>
  
  <p>Thanks in advance!</p>