Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group