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 ... 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. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
