Date problem

Поиск
Список
Период
Сортировка
От Marcelo Pereira
Тема Date problem
Дата
Msg-id Pine.LNX.4.20.0301271456020.15142-100000@ni.hmmg.sp.gov.br
обсуждение исходный текст
Ответы Re: Date problem  ("Ricardo Ryoiti S. Junior" <suga@netbsd.com.br>)
Список 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_______________/



В списке pgsql-general по дате отправления:

Предыдущее
От: juleni
Дата:
Сообщение: Function returns mutliple rows - HELP
Следующее
От: will trillich
Дата:
Сообщение: Re: too many users for postgresql? :)