title: T-SQL how to convert hour (int value) in hh:mm format
body: <p>I want to convert the variables HOUR (INT), in time in this format hh:mm.
  So I have this code;</p>
  
  <pre><code>declare @HOUR_NEW AS INT = 12
  DECLARE @RISULTATO AS NVARCHAR(12)
  SET @RISULTATO = CONVERT(VARCHAR(12),@HOUR_NEW,108)
  SELECT @RISULTATO
  </code></pre>
  
  <p>I want the output is like this 12:00 but the select return 12</p>