There are 30 days in April.
On Apr 21, 2009 2:34pm, Merlin Moncure <mmoncure@xxxxxxxxx> wrote:
> 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
> >
>
> > 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
>
