Обсуждение: problem GMT time

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

problem GMT time

От
"frank_lupo"
Дата:
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



Re: problem GMT time

От
Tom Lane
Дата:
"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