Re: [BUGS] [ADMIN] Date Return must be As per Natural Calander

2003-03-03 Thread Tim Ellis
On Mon, 2003-02-24 at 23:03, Oliver Elphick wrote: > different for different countries. There was a discussion of this on > the patches list recently > (http://archives.postgresql.org/pgsql-patches/2003-02/msg00038.php and > the surrounding thread). The SQL spec calls for the Gregorian calendar >

Re: [BUGS] [ADMIN] Date Return must be As per Natural Calander

2003-03-03 Thread Ross J. Reedstrom
On Mon, Feb 24, 2003 at 11:06:38PM -0500, Tom Lane wrote: > Robert Treat <[EMAIL PROTECTED]> writes: > > I guess adding 1 day to 1752-09-02 should give us 1752-09-14, but your > > right, it gives us 1752-09-03. > > As was pointed out at length just recently, the transition from Julian > to Gregori

Re: [BUGS] [ADMIN] Date Return must be As per Natural Calander

2003-02-25 Thread Oliver Elphick
On Tue, 2003-02-25 at 22:08, Tim Ellis wrote: > On Mon, 2003-02-24 at 23:03, Oliver Elphick wrote: > > different for different countries. There was a discussion of this on > > the patches list recently > > (http://archives.postgresql.org/pgsql-patches/2003-02/msg00038.php and > > the surrounding t

Re: [BUGS] [ADMIN] Date Return must be As per Natural Calander

2003-02-25 Thread Oliver Elphick
On Mon, 2003-02-24 at 22:59, Robert Treat wrote: > [EMAIL PROTECTED] rms_db]$ cal 9 1752 >September 1752 > Su Mo Tu We Th Fr Sa >1 2 14 15 16 > 17 18 19 20 21 22 23 > 24 25 26 27 28 29 30 > > I guess adding 1 day to 1752-09-02 should give us 1752-09-14, but your > right, it gives us

Re: [BUGS] [ADMIN] Date Return must be As per Natural Calander

2003-02-24 Thread Tom Lane
Robert Treat <[EMAIL PROTECTED]> writes: > I guess adding 1 day to 1752-09-02 should give us 1752-09-14, but your > right, it gives us 1752-09-03. As was pointed out at length just recently, the transition from Julian to Gregorian calendars happened at different times in different places. So the a

Re: [BUGS] [ADMIN] Date Return must be As per Natural Calander

2003-02-24 Thread Robert Treat
[EMAIL PROTECTED] rms_db]$ cal 9 1752 September 1752 Su Mo Tu We Th Fr Sa 1 2 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 I guess adding 1 day to 1752-09-02 should give us 1752-09-14, but your right, it gives us 1752-09-03. Forwarding this to -bugs Robert Treat On Sun, 200