Received: from makus.postgresql.org (makus.postgresql.org [98.129.198.125]) by mail.postgresql.org (Postfix) with ESMTP id 13BB218BA22E for ; Wed, 18 Apr 2012 16:39:40 -0300 (ADT) Received: from gwmta.wicourts.gov ([165.219.244.99] helo=gw.wicourts.gov) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1SKaj4-0003FZ-ID for pgsql-docs@postgresql.org; Wed, 18 Apr 2012 19:39:40 +0000 Received: from Courts-MTA by gw.wicourts.gov with Novell_GroupWise; Wed, 18 Apr 2012 14:39:25 -0500 Message-Id: <4F8ED21402000025000470FA@gw.wicourts.gov> X-Mailer: Novell GroupWise Internet Agent 8.0.2 Date: Wed, 18 Apr 2012 14:39:16 -0500 From: "Kevin Grittner" To: , Subject: Re: Date/Time Types : internals References: <4F8F0F71.20500@free.fr> In-Reply-To: <4F8F0F71.20500@free.fr> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit Content-Disposition: inline X-Pg-Spam-Score: -4.2 (----) X-Archive-Number: 201204/36 X-Sequence-Number: 7290 Florence Cousin wrote: > At the bottom of the page about Date/Time types ( > http://www.postgresql.org/docs/9.1/interactive/datatype-datetime.html > ) > there is this sentence : > > Date conventions before the 19th century make for interesting > reading, but are not consistent enough to warrant coding into a > date/time handler. > > > This sentence seemed very strange to me, and I am not sure to > really understand what it implies (or not) for the user. Could > someone explain that this really means and implies? You can get some idea by reading this page, especially the "Adoption" section: http://en.wikipedia.org/wiki/Gregorian_calendar I guess the point is that for hundreds of years, the same day could have a different date depending which country's calendar you were looking at. I'm not entirely clear why there's a problem if you pick the Gregorian calendar and apply it retroactively. If George Washington was able to adapt to his birthday changing, I think I could deal with it, too: http://www.archives.gov/legislative/features/washington/ II mean, there are still a lot of other calendars in use today, and we don't let that stop us from using the Gregorian calendar. -Kevin