Thread: Please help - Bad date external representation problems

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)