Re: date out of range for timestamp

From: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
To: David Rericha <d(dot)rericha(at)healthcareoss(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: date out of range for timestamp
Date: 2010-12-29 00:18:20
Message-ID: AANLkTikQvbpLwkD-EsMUXWbG6BAMkXtHPqgu+nqyS4rC@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Dec 28, 2010 at 5:02 PM, David Rericha
<d(dot)rericha(at)healthcareoss(dot)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?

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2010-12-29 01:36:20 Re: date out of range for timestamp
Previous Message David Rericha 2010-12-29 00:02:59 date out of range for timestamp