>I would have expected 0:00, not 12:00. Does this tie into julianday >being a 12 hour offset?
Six centuries or so ago it was "kind of difficult" to measure when the sun was "directly underfoot" at the prime meridian (0 deg, or Greenwich England, more or less) when your observation point was located on the prime meridian. It was pretty easy however to be able to tell when "noon" is (when the sun is at its maximum altitude) by an observer at the prime meridian. So the juliandate is measures a day from noon to noon. The modified Julian Day uses a "day" going from midnight to midnight at the prime meridian (by that time arithmetic had been invented so it was possible to calculate "midnight" even though you cannot see through the earth). :) _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users