Timezone calculation question

From: Роман Маширов <mrj(at)nandu(dot)ru>
To: pgsql-general(at)postgresql(dot)org
Subject: Timezone calculation question
Date: 2009-03-24 10:33:44
Message-ID: 49C8B708.9030503@nandu.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Seems I've missed something important about time zones. On my server
i've got local timezone 'W-SU' (Moscow time):

=> show timezone;
TimeZone
----------
W-SU

=> select now();
now
-------------------------------
2009-03-24 13:23:39.655057+03

Till now all seems ok. Than i'm trying to figure out local time at near
region:

=> select now() at time zone 'UTC+4';
timezone
----------------------------
2009-03-24 06:28:30.383373

select now() at time zone 'UTC+3';
timezone
----------------------------
2009-03-24 07:24:11.011075

Seems like zone offset been added twice...
Server 8.3.5, OS FreeBSD 7.0-RELEASE

Which way should i get correct local time, when i've got timestamp with
timezone and name of the target timezone?

Thanks beforehand
--
MRJ

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daniel Verite 2009-03-24 11:24:20 Re: text column constraint, newbie question
Previous Message Torsten Zühlsdorff 2009-03-24 10:01:08 Re: Fulltext: problem with english words in german text