From: | Shridhar Daithankar <ghodechhap(at)ghodechhap(dot)net> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Subject: | Re: timestamp with timezone and time zone name |
Date: | 2012-08-08 03:36:16 |
Message-ID: | 1654713.QxbaFkIYo5@bheem |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tuesday 07 Aug 2012 12:21:04 AM Tom Lane wrote:
> Shridhar Daithankar <ghodechhap(at)ghodechhap(dot)net> writes:
> > I am wondering, why following two values result in a shift by 3.5 hours. I
> > would expect them to be identical.
> >
> > I understand that canonical time zone names could be ambiguous at times
> > but I think IST is not one of them.
>
> I don't know why you'd think that ...
>
> src/timezone/tznames/Asia.txt:IST 19800 # Indian Standard Time
> src/timezone/tznames/Asia.txt:IST 7200 # Israel Standard Time
My bad.. should have searched a bit more.
>
> ... and there's some references to "Irish Summer Time" in the Olson
> database, as well. IIRC, IST was one of the primary problems that
> forced us to invent the "timezone_abbreviations" configuration
> mechanism. Try setting that to "India" if you want the 05:30 meaning.
Thanks. I will stick to the numerical offsets for uniformity.
--
Regards
Shridhar
From | Date | Subject | |
---|---|---|---|
Next Message | John R Pierce | 2012-08-08 07:46:34 | Re: Installation faillure version 8.4.12 |
Previous Message | Craig Ringer | 2012-08-08 01:14:23 | Re: PostgreSQL 9.1 product code |