Setting Timezone Fails??

From: Çağıl Şeker <cagils(at)biznet(dot)com(dot)tr>
To: "PostgreSQL General Mailing List (E-mail)" <pgsql-General(at)postgresql(dot)Org>
Subject: Setting Timezone Fails??
Date: 2002-11-20 15:06:53
Message-ID: 94327A2FE8C87C4C89A82DBE9E7B2B3F086812@beetle.biznet.com.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

(Sorry, the subject line was incorrect in my previous mail. I'm repeating my question:)

I am using postgreSQL on Cygwin on W2K. I can not set time zone. The log is below:

EDYS=# set timezone to UTC;
SET VARIABLE
EDYS=# show timezone;
NOTICE: Time zone is 'utc'
EDYS=# SELECT current_timestamp;
timestamptz
---------------------------------------------
20/11/2002 14:38:41.111625 GMT

How can I change that GMT to "+2" or smt other.???

Tnx.
------------------
"Yes, I am a criminal. My crime is that of outsmarting you. Something that you'll never forgive me for!" - The Mentor'86 (Hacker's Manifesto)

Browse pgsql-general by date

  From Date Subject
Next Message Williams, Travis L, NPONS 2002-11-20 16:38:20 Grant question..
Previous Message Çagil Seker 2002-11-20 14:40:22 Re: Bug with sequence