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)