European datestyle

Started by javier garcia - CEBASalmost 23 years ago2 messagesgeneral
Jump to latest
#1javier garcia - CEBAS
rn001@cebas.csic.es

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

#2Joel Rodrigues
borgempath@Phreaker.net
In reply to: javier garcia - CEBAS (#1)
Re: European datestyle

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