title: Convert Julian Date to Timestamp in PostgreSQL
body: <p>I have a table full of "Julian Dates", that is the number of days and seconds away from <strong>1/1/2035</strong>. I need to convert these to normal postgres timestamps. Can anyone help?</p>
  
  <pre><code>--Converts '2000-06-20 12:30:15' into an Epoch time base which gives a result of -12612.478993055556
  select (EXTRACT(epoch FROM ('2000-06-20 12:30:15'::timestamp - '2035-01-01 00:00:00'))/86400.00) as run_ts
  
  --Question, how to convert -12612.478993055556 back into '2000-06-20 12:30:15'
  select -12612.478993055556 ??? as run_ts
  </code></pre>