Обсуждение: problem set TIMEZONE

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

problem set TIMEZONE

От
"frank_lupo"
Дата:
I work on win2000 using cygwin.

gedis30=# select now();
              now
--------------------------------
 09/07/2002 09:33:27.156341 GMT
(1 row)

The time of windows is 11:33:27.
--
Because the time postgres is not equal to time windows ?

Bye !!
Frank Lupo (Wolf) !!



--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f

Sponsor:
Su www.oliviero.it trovi prodotti naturali per dimagrire senza fatica.
Come l'efficace Lipo Block Set. Scoprilo qui.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=641&d=19-7

Re: problem set TIMEZONE

От
Thomas Lockhart
Дата:
> I work on win2000 using cygwin.
> gedis30=# select now();
> --------------------------------
>  09/07/2002 09:33:27.156341 GMT
> The time of windows is 11:33:27.
> Because the time postgres is not equal to time windows ?

It seems that your PostgreSQL backend does not have a time zone set
which can be interpreted by the cygwin date/time routines. You are
probably two hours away from GMT, right? Test using SET TIME ZONE within
Postgres, choosing a value or a string which is actually installed and
valid.

                  - Thomas