title: Convert 5 digit number to date
body: <p>I apologize in advance because I am sure this question has been asked before, but I don't know the name of the type of date I am working with.</p>
  
  <p>How do I convert a date in this 5-digit form (e.g. 41867) into a regular yyyy-dd-mm in SQL Server?</p>