Re: problem set TIMEZONE

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: frank_lupo <frank_lupo(at)email(dot)it>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: problem set TIMEZONE
Date: 2002-07-19 13:29:13
Message-ID: 3D381429.C0D1DC77@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-07-19 13:31:05 Re: [SQL] id and ID in CREATE TABLE
Previous Message Tom Lane 2002-07-19 13:16:14 Re: Can't link to libpq