title: Format SQL Server 2012 Time(7) to "HH:mm"
body: <p>I have <code>Time(7)</code> columns for each day in the week and I want to format it as <code>HH:mm</code></p>
  
  <p><img src="https://i.stack.imgur.com/Nqe54.png" alt="enter image description here"></p>
  
  <p>I tried to use SQL Server 2012 new <code>FORMAT</code> function, but it only shows the <code>NULL</code> value.</p>
  
  <p><img src="https://i.stack.imgur.com/7MwKu.png" alt="enter image description here"></p>
  
  <p>How can I format a <code>time(7)</code> datatype to display as <code>HH:mm</code>?</p>