X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D0A55475F6A for ; Fri, 2 May 2003 11:34:57 -0400 (EDT) Received: from rtlocal.trade-india.com (mail-relay.trade-india.com [203.196.129.235]) by postgresql.org (Postfix) with SMTP id 4BD2F475E9D for ; Fri, 2 May 2003 11:34:48 -0400 (EDT) Received: (qmail 27488 invoked from network); 2 May 2003 15:35:48 -0000 Received: from unknown (HELO system67.trade-india-local.com) (unknown) by unknown with SMTP; 2 May 2003 15:35:48 -0000 From: Rajesh Kumar Mallah Organization: Infocom Network Limited To: Tom Lane Subject: Re: timeofday() and now() issue.. Date: Fri, 2 May 2003 21:06:49 +0530 User-Agent: KMail/1.5 Cc: pgsql-sql@postgresql.org References: <200305021844.35194.mallah@trade-india.com> <200305022037.09625.mallah@trade-india.com> <10656.1051888606@sss.pgh.pa.us> In-Reply-To: <10656.1051888606@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200305022106.49806.mallah@trade-india.com> X-Spam-Status: No, hits=-33.1 required=5.0 tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,SIGNATURE_SHORT_SPARSE, USER_AGENT autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/28 X-Sequence-Number: 13193 I *think* i do this in Redhat Linux. TZ='Asia/Calcutta'; export TZ Yeah *MANY A TIMES* i felt like raising this issue that IST is indian standard times not Israel Standart Time as mentioned in http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=x11875.html hmm ignore my ignorance , i am not knowledgable abt timezones. regds mallah. On Friday 02 May 2003 8:46 pm, Tom Lane wrote: > Rajesh Kumar Mallah writes: > > tradein_clients=# SELECT timeofday(); > > +-------------------------------------+ > > > > | timeofday | > > > > +-------------------------------------+ > > > > | Fri May 02 20:34:13.634355 2003 IST | > > > > +-------------------------------------+ > > Hmm. Looking in datetime.c, I see that Postgres believes "IST" is > Israel Standard Time, GMT+2. So that explains the discrepancy, > if you think it's GMT+5.5. What exactly are you doing to set the > system timezone? > > regards, tom lane -- Rajesh Kumar Mallah, Project Manager (Development) Infocom Network Limited, New Delhi phone: +91(11)6152172 (221) (L) ,9811255597 (M) Visit http://www.trade-india.com , India's Leading B2B eMarketplace.