title: Extracting hours from a DateTime (SQL Server 2005)
body: <p>I can extract the month and day by using <code>Day(Date())</code>, <code>Month(Date())</code>. I can't extract hours, with <code>HOUR(Date())</code>. I get the following error.</p>
  
  <pre><code>'HOUR' is not a recognized built-in function name.
  </code></pre>
  
  <p>How can I extract hours?</p>