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
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 |