| 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: | Whole Thread | Raw Message | 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 |