Julian day calculation is wrong (strictly speaking)

From: Christian Ullrich <chris(at)chrullrich(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Julian day calculation is wrong (strictly speaking)
Date: 2002-08-05 12:39:35
Message-ID: 20020805123935.GC2477@christian.chrullrich.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello!

I'm using the Julian Day Count for storage of dates in my
application, because I don't need sub-day resolution and
PostgreSQL makes my life much simpler because it can convert
to and from JD by itself.

However, I've found that the method which is used to generate
the Julian Day for a given date in the Gregorian Calendar is
somewhat wrong: It returns always the number of the JD that
starts at noon on a given date, disregarding the time of day.

Now, I'm not going to complain too loudly about this, because
it's just what I need -- I'm simplifying the calculations in
my app in just the same way. But it's still a nonstandard
behaviour which could be a problem to some people.

I don't know what would be the best way to fix this (or if it
needs to be fixed at all); I just wanted to remind you of this.
Feel free to disregard this message.

--
Christian Ullrich Registrierter Linux-User #125183

"Deliver."

Browse pgsql-general by date

  From Date Subject
Next Message Jakub Ouhrabka 2002-08-05 13:09:14 Re: Memory usage / concept
Previous Message Nikhil G. Daddikar 2002-08-05 12:36:33 Update and foreign key indices