title: How do I convert time into an integer in SQL Server
body: <p>I have a date column and a time column that are integers</p>
  
  <p>I converted the date portion like this  </p>
  
  <pre><code>select convert(int, convert(varchar(10), getdate(), 112))
  </code></pre>
  
  <p>I thought I could do the same with this query that gives the time in HH:mm:ss</p>
  
  <pre><code>SELECT CONVERT(VARCHAR(8), GETDATE(), 108)
  </code></pre>
  
  <p>How do I convert just the time into an integer?</p>