On Tue, Apr 21, 2009 at 7:02 AM, Geoff Caplan <geoff@xxxxxxxxx> wrote: > Hi folks > > Looks like there's something I'm not understanding about date/time queries > on a date field. > > I have a param query that includes the statement: > > AND active_from_date <= $2 > > where $2 is a well-formed ISO date. > > Query works as expected when there are records in the result set. When the > result set is empty, PG throws an error: > > date/time field value out of range: "2011-4-31" "2011-4-31" is not a well formed ISO date. merlin -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
