problem GMT time
I work in win2000
I set:
PGDATESTYLE=SQL,European
PGTZ=Europe/Rome
gedis30=# select now();
now
--------------------------------
09/07/2002 09:33:27.156341 GMT
(1 row)
The time of windows is 11:33:27.
Help me...
Bye !!
Frank Lupo (Wolf) !!
--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
Sponsor:
Cerchi un idraulico, un elettricista , un imbianchino, una baby sitter?
su QXservice trovi la soluzione ai mille imprevisti della tua casa, con un
click!
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=534&d=9-7
"frank_lupo" <frank_lupo@email.it> writes:
I set:
PGDATESTYLE=SQL,European
PGTZ=Europe/Rome
gedis30=# select now();
now
--------------------------------
09/07/2002 09:33:27.156341 GMT
(1 row)
Doesn't look to me like your variable settings had any effect.
Try SQL SHOW and SET commands instead.
regards, tom lane