Re: BC date getting misinterpreted?

From: Joe Abbate <jma(at)freedomcircle(dot)com>
To: Christophe Pettus <xof(at)thebuild(dot)com>
Cc: psycopg(at)postgresql(dot)org
Subject: Re: BC date getting misinterpreted?
Date: 2018-03-26 23:36:45
Message-ID: e1ce146d-59fd-8ad6-a29f-a6a0ee938b99@freedomcircle.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: psycopg

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

In response to

Browse psycopg by date

  From Date Subject
Next Message Grant McKenzie 2018-04-15 00:35:29 Windows binary install and gssapi support
Previous Message Christophe Pettus 2018-03-26 23:20:00 Re: BC date getting misinterpreted?