How do I convert time into an integer in SQL Server

Question

I have a date column and a time column that are integers

I converted the date portion like this

select convert(int, convert(varchar(10), getdate(), 112))

I thought I could do the same with this query that gives the time in HH:mm:ss

SELECT CONVERT(VARCHAR(8), GETDATE(), 108)

How do I convert just the time into an integer?

Answer 1

This should convert your time into an integer representing seconds from midnight.

SELECT (DATEPART(hour, Col1) * 3600) + (DATEPART(minute, Col1) * 60) + DATEPART(second, Col1) as SecondsFromMidnight FROM T1;