Date problem

Hi everybody,

I am in troubles with a DATE field. Here, in Brazil, we use to write dates
as DD/MM/YYYY, so to insert a tuple today I'd execute:

INSERT INTO test (iDate) VALUES ('27/01/2003');

But it will result in 01/27/2003... and an error is showed on the
screen. When I have dates as 10th May, I would use 10/05/2003, but it will
be inserted on the database as 05/10/2003. Note it will not output an
error, but my data will be inconsistent.

How can I make PostgreSQL to use dates as DD/MM/YYYY ????

Thanks in advance and
Best Regards,

Marcelo Pereira

-- Remember that only God and ^[:w saves.
__
(_.\ © Marcelo Pereira |
/ / ___ marcelo(at)pereira(dot)com |
/ (_/ _ \__ [Math|99]-IMECC |
_______\____/_\___)___Unicamp_______________/