title: Convert Julian Date to YYYY-MM-DD
body: <p>I have searched far and wide, but I can't seem find a way to convert julian to <code>yyyy-mm-dd</code>. </p>
  
  <p>Here is the format of my julian:</p>
  
  <p>The Julian format consists of the year, the first two digits, and the day within the year, the last three digits. </p>
  
  <p>For example, <code>95076</code> is <code>March 17, 1995</code>. The <code>95</code> indicates the year and the
  <code>076</code> indicates it is the 76th day of the year.</p>
  
  <pre><code>15260
  </code></pre>
  
  <p>I have tried this but it isn't working:</p>
  
  <pre><code>dateadd(d,(convert(int,LAST_CHANGED_DATE) % 1000)-1, convert(date,(convert(varchar,convert(int,LAST_CHANGED_DATE) /1000 + 1900) + '/1/1'))) as GrgDate
  </code></pre>