Re: date out of range for timestamp - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: date out of range for timestamp
Date
Msg-id AANLkTikQvbpLwkD-EsMUXWbG6BAMkXtHPqgu+nqyS4rC@mail.gmail.com
Whole thread Raw
In response to date out of range for timestamp  (David Rericha <d.rericha@healthcareoss.com>)
List pgsql-admin
On Tue, Dec 28, 2010 at 5:02 PM, David Rericha
<d.rericha@healthcareoss.com> wrote:
> select count(*) from moms_outside_report where outreport_date <=
> '12/10/2010';
> ERROR:  date out of range for timestamp

Try using an ISO date:

select count(*) from moms_outside_report where outreport_date <= '2010-12-10';

I wonder if you've got a different date style set than you think.  What does

what does:

psql mydb
show datestyle;

show?

pgsql-admin by date:

Previous
From: David Rericha
Date:
Subject: date out of range for timestamp
Next
From: Tom Lane
Date:
Subject: Re: date out of range for timestamp