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.