"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