[sNip]
> Why shall 1752 be the default date? The original introduction of
> gregorian dates after all was in 1582. And some parts of the earth
> didn't switch before the 20th century. So, as pointed out, we'd need a
> locale dependant default.
Since a database can be serving someone in a d
On Sun, Oct 05, 2003 at 05:51:47PM -0400, Andrew Dunstan wrote:
> Perhaps we need a function or two to convert pre-gregorian dates to
> gregorian dates and vice versa, with the cutover date either a
> configuration variable (default the 1752 date) or a parameter of the
I guess that's one of the
Do to a bug in pgtypeslin I've been experimenting with the day of week
stuff a little bit and I found that we do not agree with the output of
the cal command on older dates. I have no idea which one is correct:
mm=# select to_char('1000/01/01'::date,'D');
to_char
-
4
(1 row)
Thus we bel
Tom Lane wrote:
"Andrew Dunstan" <[EMAIL PROTECTED]> writes:
Looks like it is caused by the switch to the Gregorian calendar in 1752,
when 11 days were chopped out of September ( in England and America -
elsewhere anywhere between Oct 1582 and early 20th century).
There was some discussi
"Andrew Dunstan" <[EMAIL PROTECTED]> writes:
> Looks like it is caused by the switch to the Gregorian calendar in 1752,
> when 11 days were chopped out of September ( in England and America -
> elsewhere anywhere between Oct 1582 and early 20th century).
There was some discussion awhile back about
have missed something.
cheers
andrew
- Original Message -
From: "Michael Meskes" <[EMAIL PROTECTED]>
To: "PostgreSQL Hacker" <[EMAIL PROTECTED]>
Sent: Sunday, October 05, 2003 7:06 AM
Subject: [HACKERS] Day of week question
> Do to a bug in pgtypes
Michael Meskes writes:
> mm=# select to_char('1000/01/01'::date,'D');
> to_char
> -
> 4
> (1 row)
>
> Thus we believe 1000/1/1 is a Wednesday. cal says:
> Thus 1000/1/1 is a Monday. Is this a bug in cal? Or do we produce the
> wrong output? Or do I simply misread the output?
cal takes
Do to a bug in pgtypeslin I've been experimenting with the day of week
stuff a little bit and I found that we do not agree with the output of
the cal command on older dates. I have no idea which one is correct:
mm=# select to_char('1000/01/01'::date,'D');
to_char
-
4
(1 row)
Thus we be
