Date problem - Mailing list pgsql-general

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@pereira.com   |
       / (_/ _ \__    [Math|99]-IMECC       |
_______\____/_\___)___Unicamp_______________/