title: SQL Server Select Records within a Configured Date and Time
body: <p>I have a configuration table and stored a configured value as RetIntervel as 10,8.30 PM. I need to retrieve all the records which dates are exceeded 10 days and after 8.30 PM (after 10 days and 8.30 PM). I have tried below condition and it is not getting proper result.</p>
  <pre><code>Select * From Table 
  Where 
      DATEADD(day, DATEDIFF(day,10,CreatedDate),'8:30 PM') &gt;GETDATE() 
  </code></pre>