title: How to convert a 5 digit INT to date
body: <p>I apologise if this question has been asked but I cannot find an answer that quite fits.</p>
  
  <p>I have a database with dates stored as 5 digit integers.  I can covert these to datetime, however the dates are showing in the future.  </p>
  
  <p>For example, </p>
  
  <pre><code>select convert(datetime,StartDate,103)
  from dpm.Schedule
  where ScheduleID like 50003;
  </code></pre>
  
  <p>Gives the results of </p>
  
  <p>2107-05-31 00:00:00:000 but this date should actually be 26/05/2008.</p>
  
  <p>I am pretty new to T-SQL and have looked for sometime to find the answer to this but I am reaching the end of my sanity.</p>