Datestyle and Postmaster
От | Jason Everett |
---|---|
Тема | Datestyle and Postmaster |
Дата | |
Msg-id | 3A142BBB.BD2865E6@esu10.org обсуждение исходный текст |
Ответы |
Re: Datestyle and Postmaster
|
Список | pgsql-general |
Greetings, I have upgraded Postgres to v7.0.3 on a linux machine and have run into some trouble. I am using a very old program that I didn't write but it is having some trouble with the way Postgres is handling the date. It would be easiest for me to have Postgres handle the date in this format: MM-DD-YYYY. Is it possible to have postmaster control the datestyle other than -e for the European style? I have gotten "SET DATESTYLE TO 'SQL, US'" to work using psql but I'm not quite sure how to get my programs to do the same (other than rewrite them to use the ISO, US style). Is there a way I could use the -o option in postmaster? Is there a function I could call that I could use to change this behavior? What version of postgres supported MM-DD-YYYY as the default? Does v.6.5.3 have this behavior? If so, I do have a copy of this with my data in this format. Thanks for your help, Jason
В списке pgsql-general по дате отправления: