The documentation (http://www.postgresql.org/docs/7.4/static/datetime-keywords.html) doesn’t have an entry for Indian Standard Time, nor for any other time zone with a GMT+5:30 offset.
Is this just an omission from the documentation? If so, what are the name and codes of the GMT+5:30 time zone?
Or does PostgreSQL really have no time zone that it can read for this rather important place? If so, can this problem be fixed?
(I believe the standard code for Indian Standard Time is IST, which alas conflicts with PostgreSQL’s code for Israel Standard Time, so I guess some other code needs to be used for India.)
The documentation and/or PostgreSQL itself are also missing some other GMT offsets:
These are less important than India because (except for Nepal) they only apply to a few Pacific islands, but if someone were to go in there and fix the India problem, it might be a good time to tidy these up as well.
~ TIA ~ Ken |
- [GENERAL] Does PG really lack a time zone for India... Ken Winter
- Re: [GENERAL] Does PG really lack a time zone ... Tom Lane
- Re: [GENERAL] Does PG really lack a time z... Martijn van Oosterhout
- Re: [GENERAL] Does PG really lack a ti... Tom Lane
- Re: [GENERAL] Does PG really lack ... Martijn van Oosterhout
- Re: [GENERAL] Does PG really ... Bruce Momjian
- Re: [GENERAL] Does PG really lack a time z... Ken Winter
- Re: [GENERAL] Does PG really lack a ti... Tom Lane
- Re: [GENERAL] Does PG really lack ... Ken Winter
- Re: [GENERAL] Does PG really ... Tom Lane
- Re: [GENERAL] Does PG rea... Ken Winter