Re: problem set TIMEZONE

Поиск
Список
Период
Сортировка
От Thomas Lockhart
Тема Re: problem set TIMEZONE
Дата
Msg-id 3D381429.C0D1DC77@fourpalms.org
обсуждение исходный текст
Ответ на problem set TIMEZONE  ("frank_lupo" <frank_lupo@email.it>)
Список pgsql-general
> 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

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruno Wolff III
Дата:
Сообщение: Re: select a ranking
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [SQL] id and ID in CREATE TABLE