There are 30 days in April. On Apr 21, 2009 2:34pm, Merlin Moncure <mmonc...@gmail.com> wrote:
On Tue, Apr 21, 2009 at 7:02 AM, Geoff Caplan ge...@uviva.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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
