Re: problem set TIMEZONE - Mailing list pgsql-general

From Thomas Lockhart
Subject Re: problem set TIMEZONE
Date
Msg-id 3D381429.C0D1DC77@fourpalms.org
Whole thread Raw
In response to problem set TIMEZONE  ("frank_lupo" <frank_lupo@email.it>)
List 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 by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: select a ranking
Next
From: Tom Lane
Date:
Subject: Re: [SQL] id and ID in CREATE TABLE