On Tue, Dec 28, 2010 at 5:02 PM, David Rericha <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
