From: | Tony Caduto <tony_caduto(at)amsoftwaredesign(dot)com> |
---|---|
To: | |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Weird PG 8.1.3 date error |
Date: | 2006-12-13 17:36:03 |
Message-ID: | 45803A03.70805@amsoftwaredesign.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Tom Lane wrote:
> He needs to set DateStyle to match the expected field order.
>
> regression=# show datestyle;
> DateStyle
> -----------
> ISO, MDY
> (1 row)
>
> regression=# select '08-01-2006'::date;
> date
> ------------
> 2006-08-01
> (1 row)
>
> regression=# set datestyle TO ymd;
> SET
> regression=# select '08-01-2006'::date;
> ERROR: date/time field value out of range: "08-01-2006"
> HINT: Perhaps you need a different "datestyle" setting.
> regression=#
>
>
Tom,
You were right on, that's exactly what the problem was.
I have not heard back, but I told him to set his datestyle back to the
default.
Thanks,
--
Tony
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Murphy | 2006-12-13 17:36:38 | Re: function accepting and returning rows; how to avoid |
Previous Message | Joshua D. Drake | 2006-12-13 17:27:46 | Re: Weird PG 8.1.3 date error |