Thread: BUG #2034: Wrong time zone IST
The following bug has been logged online: Bug reference: 2034 Logged by: Neeraj Malhotra Email address: malhotra_neeaj@rediffmail.com PostgreSQL version: 8.0.2 Operating system: Fedora Core 4 Description: Wrong time zone IST Details: In postgreSQL IST timezone is being used for Israel Standard Time(+2:00) which is incorrect. IST stands for Indian Standard Time(+5:30). Please correct it because it is causing problem in our applications. Thanks & Regards
On Thu, Nov 10, 2005 at 12:10:27PM +0000, Neeraj Malhotra wrote: > In postgreSQL IST timezone is being used for Israel Standard Time(+2:00) > which is incorrect. IST stands for Indian Standard Time(+5:30). Please > correct it because it is causing problem in our applications. IST means something different depending on whether you're in India, Israel, or Ireland. This has come up before; allowing users to customize it is on the developers' TODO list but nobody's gotten around to it. http://archives.postgresql.org/pgsql-bugs/2004-01/msg00202.php http://archives.postgresql.org/pgsql-hackers/2004-10/msg00766.php http://www.postgresql.org/docs/faqs.TODO.html In the first message above, Tom Lane suggests hacking src/backend/utils/adt/datetime.c if you want to fix your own system. -- Michael Fuhr
"Neeraj Malhotra" <malhotra_neeaj@rediffmail.com> writes: > In postgreSQL IST timezone is being used for Israel Standard Time(+2:00) > which is incorrect. IST stands for Indian Standard Time(+5:30). Please > correct it because it is causing problem in our applications. Unfortunately, what's "wrong" to you is "right" to the Israelis. Eventually we'll probably fix things so that the list of known timezone abbreviations is stored in a config file and can be customized for local needs more easily. In the meantime there's not a lot we can do about this sort of conflict. If you like you can make a locally modified version with your interpretation of IST --- look at the token table in src/backend/utils/adt/datetime.c. regards, tom lane