Re: data forma error in pgsql 7.1 - Mailing list pgsql-bugs

"Ivan E. Rivera Uria" <irivera@bnchq.com.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