title: How to create a time of 9pm today in SQL
body: <p>I am trying to get a <code>smalldatetime</code> value of "9pm today" in a query. I thought I could use</p>
  
  <pre><code>DATEADD(HOUR, 21, CONVERT(date, GETDATE()))
  </code></pre>
  
  <p>but SQL Server doesn't like that - I get the error</p>
  
  <blockquote>
    <p>The datepart hour is not supported by date function dateadd for data
    type date.</p>
  </blockquote>
  
  <p>Suggestions for a workaround?</p>