From: | Oliver Elphick <olly(at)lfix(dot)co(dot)uk> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | John Cochran <jdc(at)fiawol(dot)org>, pgsql-patches(at)postgresql(dot)org |
Subject: | Re: timestamp patch to extend legal range of dates. |
Date: | 2003-02-04 12:11:41 |
Message-ID: | 1044360701.2590.119.camel@linda.lfix.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-patches |
On Tue, 2003-02-04 at 04:41, Tom Lane wrote:
> John Cochran <jdc(at)fiawol(dot)org> writes:
> > Here is a patch that modifies how timestamp values are generated and
> > extends the legal range of timestamps. The overall effect is:
> > 1. For dates prior to Oct 15, 1582 it uses the Julian calendar.
> > 2. For dates on and after Oct 15, 1582, it uses the Gregorian calendar.
> >
> > The decision to have the switchover point be Oct 15, 1582 was made to cause
> > the new routines return the same values as the old routines for the largest
> > possible range. I did consider having the switchover be Sept 14, 1752 to
> > be consistent with Unix, but decided against it.
>
> This seems like rather an odd choice. Isn't the 1752 date commonly
> recognized as the start of Gregorian dating?
In the 6th Century, Bede proposed a more accurate calendar than the
Julian calendar introduced by Julius Caesar. In 1582, Pope Gregory
accepted a similar proposal and ordered the change across all the
Catholic world. Since England had rejected papal authority and the pope
was encouraging Catholic powers to attack England, his order was not
effective here, nor in some other protestant countries. It actually
took effect that year in France, Spain, Portugal and the Italian states;
parts of Germany, Belgium, the Netherlands, and Switzerland changed
within a couple of years and Hungary in 1587. The Protestant parts of
Germany changed in 1700.
In 1752, England adopted the Gregorian calendar at last, causing popular
unrest ("Give us back our 11 days!"). The American colonies adopted it
at the same time. Sweden changed in 1753 and Russia in 1918.
In 1751/2 England also changed from a new year date of 25th March to 1st
January as part of the same calendar change. (The Inland Revenue didn't
change, which is why our tax year starts on April 6th.) So in England
and America, 1751 ran from 25th March to 31st December; 1752 ran from
1st January to 2nd September and then 14th September to 31st December.
24th March 1750 was one day before 25th March 1751.
All of which adds up to: which you choose depends on what you are using
the date for. Historical records of Catholic coutries need 1582; those
of England and English colonies need 1752. Does anyone know how
historians cope when tracking both together?
--
Oliver Elphick Oliver(dot)Elphick(at)lfix(dot)co(dot)uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"That at the name of Jesus every knee should bow, of
things in heaven, and things in earth, and things
under the earth; And that every tongue should confess
that Jesus Christ is Lord, to the glory of God the
Father." Philippians 2:10,11
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-02-04 16:02:37 | Re: timestamp patch to extend legal range of dates. |
Previous Message | Bruce Momjian | 2003-02-04 11:53:49 | Re: [Fwd: [HACKERS] Coerce to Domain] |