Bad date external representation Was :[problems using pg_dump and datestyle format]

From: Leandro Rodrigo Saad Cruz <leandro(at)ibnetwork(dot)com(dot)br>
To: pgsql-admin(at)postgresql(dot)org
Subject: Bad date external representation Was :[problems using pg_dump and datestyle format]
Date: 2001-09-13 19:08:01
Message-ID: 3BA10411.4317B6B6@ibnetwork.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


Hi, I searched the mailing list and I am stuck.

INFO :

> monitorar=# SHOW DateStyle ;
> NOTICE: DateStyle is SQL with European conventions
> SHOW VARIABLE
>
> monitorar=# SELECT oid from reservas where data_comp = '20/08/2001';
> oid
> --------
> 254376
> (1 row)
>
> monitorar=# \d reservas
> Table "reservas"
> Attribute | Type | Modifier
> -------------------+-----------------------+----------
> flag | smallint |
> num_org | character varying(6) |
> nome_org | character varying(30) |
> tipo_reserva | character varying(3) |
> num_reserva | bigint | not null
> sequencia | character varying(4) | not null
> cod_material | character varying(20) |
> desc_material | character varying(30) |
> unidade | character varying(2) |
> quant_total | integer |
> quant_atendida_ac | integer |
> quant_dia | integer |
> quant_pendente | integer |
> data_integracao | date |
> data_necessidade | date |
> data_separacao | date |
> data_nf | date |
> data_envio | date |
> data_entrega | date |
> num_nf | character varying(10) |
> num_conhecimento | character varying(10) |
> nome_trans | character varying(30) |
> data_comp | date |
> Indices: data_comp_reservas_key,
> reservas_pkey

PROBLEM :

> monitorar=# SELECT oid from reservas where data_comp < '20/08/2001';
> ERROR: Bad date external representation '08/20/2001'

--
Leandro Rodrigo Saad Cruz
IT - Inter Business Tecnologia e Servicos (IB)

Attachment Content-Type Size
leandro.vcf text/x-vcard 187 bytes

Browse pgsql-admin by date

  From Date Subject
Next Message Tauren Mills 2001-09-14 15:22:40 Problem with database: FATAL 1: cannot find attribute 24 of relation
Previous Message Leandro Rodrigo Saad Cruz 2001-09-13 14:03:57 Bad date external representation Was :[problems using pg_dump and datestyle format]