| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Shridhar Daithankar <ghodechhap(at)ghodechhap(dot)net> |
| Cc: | pg-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: timestamp with timezone and time zone name |
| Date: | 2012-08-07 04:21:04 |
| Message-ID: | 6407.1344313264@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
... 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2012-08-07 08:07:01 | Re: How does connect privilege works? |
| Previous Message | Shridhar Daithankar | 2012-08-07 03:53:29 | timestamp with timezone and time zone name |