Extracting hours from a DateTime (SQL Server 2005)

Question

I can extract the month and day by using Day(Date()), Month(Date()). I cant extract hours, with HOUR(Date()). I get the following error.

'HOUR' is not a recognized built-in function name.

How can I extract hours?

Answer 1

SELECT DATEPART(hh, GETDATE());

Answer 2

Use datepart.

E.g.:

datepart(hh, date)