| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Ivan E(dot) Rivera Uria" <irivera(at)bnchq(dot)com(dot)mx> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: data forma error in pgsql 7.1 |
| Date: | 2003-10-17 19:05:07 |
| Message-ID: | 25428.1066417507@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
"Ivan E. Rivera Uria" <irivera(at)bnchq(dot)com(dot)mx> writes:
> the date format that we use is DD/MM/YYYY but whet we execute a select
> command we get this information:
Sounds to me like you haven't told the database what format you're
using. See the DATESTYLE parameter; you need to select "european"
format to get it to default to dd-before-mm date order.
> We need to know if is necessary to install some patch to fix this
> problem or upgrade the database.
An upgrade would be a good idea in any case. 7.1.3 is pretty old.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan E. Rivera Uria | 2003-10-17 19:37:25 | data forma error in pgsql 7.1 |
| Previous Message | Tom Lane | 2003-10-16 23:58:37 | Re: Bug in the information_schema.referential_constraints view |