Thread: 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