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)
begin:vcard n:Saad Cruz;Leandro x-mozilla-html:FALSE org:Inter Business;IT adr:;;;;;; version:2.1 email;internet:[EMAIL PROTECTED] x-mozilla-cpt:;0 fn:Leandro Saad Cruz end:vcard
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
