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."
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 |