Hi all. I'm using postgresql 7.1release-3.potato.1 on a debian box . this error is aways happening :
NOTICE: DateStyle is SQL with European conventions SHOW VARIABLE monitorar=> SELECT oid from reservas where data_comp < '22/08/2001'; ERROR: Bad date external representation '08/20/2001' the strange thing is monitorar=> set DateStyle to us; SET VARIABLE monitorar=> SHOW DateStyle ; NOTICE: DateStyle is SQL with US (NonEuropean) conventions SHOW VARIABLE monitorar=> SELECT oid from reservas where data_comp < '22/08/2001'; gives me the right results. whats wrong ?? -- Leandro Rodrigo Saad Cruz IT - Inter Business Tecnologia e Servicos (IB) ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
