julian day number input/output

From: Matt Beauregard <matt(at)designscape(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: julian day number input/output
Date: 2001-01-12 05:17:57
Message-ID: 20010112161757.C55689@designscape.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How do I turn a timestamp into a Julian day number with decimal part?
How do I turn one of these back into a timestamp?

tia,

--
Matt Beauregard
Information Technology Operations, DesignScape

Ph: +61 2 9361 4233 Fx: +61 2 9361 4633

Browse pgsql-general by date

  From Date Subject
Next Message Thomas T. Thai 2001-01-12 05:32:09 mnogosearch -- pgsql seem so slow, please help me find out why
Previous Message Tom Lane 2001-01-12 05:13:17 Re: exit status 26