title: SQL extracting hour and minute from date into a single column
body: <p>I have a column in the format YYYY-MM-DDBHH:MI:SS and I wish to extract just the hour and minutes from this into a column. Currently on the code they are using</p>
  
  <pre><code> Extract(HOUR From table) AS HR
  , Extract(MINUTE From table) AS MN
  </code></pre>
  
  <p>but this outputs them into 2 columns. I'm new to SQL so is there an easier way to extract hour and minutes into one column in the format HH:MI.</p>
  
  <p>Thanks</p>