Extracting hours from a DateTime (SQL Server 2005)
I can extract the month and day by using Day(Date()), Month(Date()). I can’t extract hours, with HOUR(Date()). I get the following error. ‘HOUR’ is not a recognized built-in function name. How can I extract hours? 12 Answers 12