Date problem
От | Marcelo Pereira |
---|---|
Тема | Date problem |
Дата | |
Msg-id | Pine.LNX.4.20.0301271456020.15142-100000@ni.hmmg.sp.gov.br обсуждение исходный текст |
Ответы |
Re: Date problem
|
Список | 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 по дате отправления: