title: Convert a Julian Date to Calendar date in Postgresql
body: <p>I am attempting to convert a Julian Date into a Calendar Date but I can not find the correct PostgreSQL function to do so.</p>
  
  <p>For Example: Given the Julian Date = 2456782, I would want something like 2014/05/04 back.</p>
  
  <p>Thank You,</p>