title: SQL - set time to tomorrow at 8AM
body: <p>I am trying to take in any date where the time occurs after 12PM and set it to 8AM the next day.</p>
  
  <p>I know how to add a time or hours to a date using <code>DATEADD</code>, but not how to just set it to the next day at a specific time. </p>
  
  <p>Trying to use SQL Server / Transact-SQL.</p>
  
  <p>The only way i can think to do this is to create a function that evaluates the date and returns a <code>DATEADD</code> to the hour based on the input to get it to 8AM.</p>