PostgreSQL Bugs - BUG #2034: Wrong time zone IST

Author

BUG #2034: Wrong time zone IST

Neeraj Malhotra

2005-11-10, 9:24 am

The following bug has been logged online:

Bug reference: 2034
Logged by: Neeraj Malhotra
Email address: malhotra_neeaj@redif
fmail.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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Michael Fuhr

2005-11-10, 9:24 am

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/pgsq...01/msg00202.php
http://archives.postgresql.org/pgsq...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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly

Tom Lane

2005-11-10, 9:24 am

"Neeraj Malhotra" < malhotra_neeaj@redif
fmail.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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Sponsored Links