Postgres Pro
Downloads
Home   >   mailing lists

Re: BC date getting misinterpreted? - Mailing list psycopg

From Joe Abbate
Subject Re: BC date getting misinterpreted?
Date
Msg-id e1ce146d-59fd-8ad6-a29f-a6a0ee938b99@freedomcircle.com
Whole thread Raw
In response to Re: BC date getting misinterpreted?  (Christophe Pettus <xof@thebuild.com>)
List psycopg
Tree view 
On 26/03/18 19:15, Christophe Pettus wrote:
> In both 2.7 and 3.6, datetime.MINYEAR is 1, so I'm a bit surprised this ever worked.

OK, now I see what caused my problem.  The date column was added to the 
query, so that in certain instances it could be used in the ORDER BY 
(there are more details as to why but I won't bore you with them).

No date arithmetic on those dates (yet), so to_char() and extract() are 
fine for the other uses.

Thanks.

Joe

psycopg by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: BC date getting misinterpreted?
Next
From: Grant McKenzie
Date:
Subject: Windows binary install and gssapi support