title: SQL: How to set a custom MAX datetime?
body: <p>I tried to convert a <strong>non-temporal</strong> table into a <strong>temporal</strong> one. I have two columns, an effective and expiration date.</p>
  <p>My expiration dates are set to <code>2099-12-31 00:00:00</code> which SQL does not like (I guessing it wants <code>9999-12-31</code> etc).</p>
  <p>A timestamp this high is unsupported by Pandas in <strong>Python</strong>, so using such a high date is impractical.</p>
  <p>How can I tell SQL to change its max date to something lower / practical?</p>
  <p>I get this error:</p>
  <blockquote>
  <p>ADD PERIOD FOR SYSTEM_TIME failed because table contains records where end of period is not equal to MAX datetime.</p>
  </blockquote>