| From: | milos(dot)babic(at)gmail(dot)com |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com>, Geoff Caplan <geoff(at)uviva(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: This is my first template |
| Date: | 2009-04-21 11:38:39 |
| Message-ID: | 001636416c7798ecc004680f1620@google.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
There are 30 days in April.
On Apr 21, 2009 2:34pm, Merlin Moncure <mmoncure(at)gmail(dot)com> wrote:
> On Tue, Apr 21, 2009 at 7:02 AM, Geoff Caplan geoff(at)uviva(dot)com> 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(at)postgresql(dot)org)
> To make changes to your subscription:
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jasen Betts | 2009-04-21 12:11:26 | Re: DISTINCT ON without ORDER BY |
| Previous Message | Merlin Moncure | 2009-04-21 11:34:11 | Re: This is my first template |