pg.ddx.io  pgsql-docs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: cousinflo@free.fr
To: pgsql-docs@postgresql.org
Subject: Re: Date/Time Types : internals
Date: Wed, 18 Apr 2012 14:39:16 -0500
Message-ID: <4F8ED21402000025000470FA@gw.wicourts.gov> (raw)
In-Reply-To: <4F8F0F71.20500@free.fr>
References: <4F8F0F71.20500@free.fr>

Florence Cousin <cousinflo@free.fr> 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



view thread (7+ messages)  latest in thread

Message-ID: <4F8ED21402000025000470FA@gw.wicourts.gov>
Permalink:  ../4F8ED21402000025000470FA@gw.wicourts.gov/
Also on:    postgresql.org/message-id/4F8ED21402000025000470FA@gw.wicourts.gov

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-docs@postgresql.org
  Cc: Kevin.Grittner@wicourts.gov, cousinflo@free.fr
  Subject: Re: Date/Time Types : internals
  In-Reply-To: <4F8ED21402000025000470FA@gw.wicourts.gov>
  References: <4F8F0F71.20500@free.fr> <4F8ED21402000025000470FA@gw.wicourts.gov>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox