Re: #203: Timestamps "BC" raise "ValueError: second must be in 0..59"

Tim Roberts <[email protected]>
Newsgroups gmane.comp.python.db.psycopg.devel
Organization Providenza & Boekelheide, Inc.
Message-ID <[email protected]>
James Henstridge wrote:
> One place where mx.DateTime and PostgreSQL disagree is on whether
> there is a "year zero".  With Postgres, the two years before 0001 are
> 0001 BC and 0002 BC .  With mx.DateTime, they are 0000 and -0001.  The
> typecast and adapter code takes this into account.
>   

Interesting; I would have to call that a bug in mx.  In calendar terms, 
there is no year 0.  The day before Jan 1, 1 AD was Dec 31, 1 BC.

I suppose one could handle this easily enough in the conversions, but it 
seems surprising.

-- 
Tim Roberts, [email protected]
Providenza & Boekelheide, Inc.
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.