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