Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] Dates BC.

From: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Dann Corbit <DCorbit(at)connx(dot)com>, Kurt Roeckx <Q(at)ping(dot)be>,PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [HACKERS] Dates BC.
Date: 2004-03-30 07:19:15
Message-ID: 20040330071914.GA17619@zf.jcu.cz (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
On Mon, Mar 29, 2004 at 03:37:07PM -0500, Bruce Momjian wrote:
> Karel Zak wrote:
> > On Fri, Dec 19, 2003 at 01:12:08AM -0800, Dann Corbit wrote:
> > > There is no zero calendar year.  The first year of Anno Domini is 1.  It's ordinal, not cardinal.
> > 
> >  I agree. But  the follow quoted  code is  not use in  date_part() there
> >  Kurt  found bug. It's  used  in to_timestamp()  _only_,  and it  works,
> >  because tm2timestamp() and date2j() work with zero year.
> 
> I have also add a doc mention to my patch that mentions that there is no
> 0 AD, and therefore subtraction of BC years from AD years must be done
> with caution.

 The patch seems good for me. Thanks.

    Karel

-- 
 Karel Zak  <zakkr(at)zf(dot)jcu(dot)cz>
 http://home.zf.jcu.cz/~zakkr/

In response to

pgsql-hackers by date

Next:From: Gavin SherryDate: 2004-03-30 08:20:08
Subject: Re: pg_dump end comment
Previous:From: Bruce MomjianDate: 2004-03-30 05:33:37
Subject: Re: pg_dump end comment

pgsql-patches by date

Next:From: Gavin SherryDate: 2004-03-30 08:20:08
Subject: Re: pg_dump end comment
Previous:From: Bruce MomjianDate: 2004-03-30 05:33:37
Subject: Re: pg_dump end comment

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group