|
On Tuesday 07 Aug 2012 12:21:04 AM Tom Lane wrote: > Shridhar Daithankar <ghodechhap@xxxxxxxxxxxxxx> 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 |
