title: Using a check constraint on a date
body: <p>I want to make sure that a person's Date of Birth must be less than the current date.
  So I declared in a table:</p>
  
  <pre><code>    staff_dob SMALLDATETIME NOT NULL CHECK (GETDATE() &lt; staff_dob)
  </code></pre>
  
  <p>But when I keep getting conflicts with the check constraint. How do I fix this? Do I need to formate GETDATE() into a proper format that I use? I'm unsure on how to do it.</p>