Обсуждение: European datestyle

Поиск
Список
Период
Сортировка

European datestyle

От
javier garcia - CEBAS
Дата:
Hi;
I've needed to change the variable DateStyle to European conventions with the
SET command.
But when I restart the psql client, the datestyle is again 'non-european
conventions". How could I force to use the european datestyle always.
(I also use Access2000 as a client. Up to the date, I use three integer
fields for year, months and days to have no problem, but I would like to use
normal dates). So. How can I be sure that the server always understand
'european dates'?
(aaaa-mm-dd)

Thanks and regards

Javier

Re: European datestyle

От
Joel Rodrigues
Дата:
Javier, I put these lines in my .tcshrc file in my home
directory (on Mac OS X), you'd have to use whatever startup file
your *nix shell uses :


setenv PGCLIENTENCODING UNICODE
setenv PGDATESTYLE 'ISO,European'
setenv PGTZ UTC


Cheers !
- Joel Rodrigues