SELECT DATEPART(HOUR, GETDATE()); code example

Example: get hour from date sql

SELECT DATEPART(HOUR, GETDATE());