title: Day or Night CHECK in SQL Server
body: <p>I have a Time_Interval column that should only have the values ​​&quot;day&quot; or &quot;night&quot;. It will be &quot;day&quot; if it is from 8AM to 8PM and &quot;night&quot; if it is from 8PM to 8AM.
  use CHECK for value entry.</p>
  <p>Maybe I need use a trigger that checks the time in the getdate?</p>
  <p>I have this:</p>
  <pre><code>CREATE TABLE Calls (
    Time_Interval VARCHAR(10) CHECK (
       Time_Interval='day' 
       OR Time_Interval='night'
     )
  )
  </code></pre>