On Tue, Dec 28, 2010 at 5:02 PM, David Rericha <d.rericha@xxxxxxxxxxxxxxxxx> 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? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
