X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 30667476036
	for <pgsql-sql@postgresql.org>; Sun,  4 May 2003 06:47:25 -0400 (EDT)
Received: from rtlocal.trade-india.com (mail-relay.trade-india.com
	[203.196.129.235])
	by postgresql.org (Postfix) with SMTP id 30567475A45
	for <pgsql-sql@postgresql.org>; Sun,  4 May 2003 06:47:11 -0400 (EDT)
Received: (qmail 1425 invoked from network); 4 May 2003 10:48:03 -0000
Received: from unknown (HELO system67.trade-india-local.com) (unknown)
	by unknown with SMTP; 4 May 2003 10:48:03 -0000
From: Rajesh Kumar Mallah <mallah@trade-india.com>
Organization: Infocom Network Limited
To: Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: timeofday() and now() issue..
Date: Sun, 4 May 2003 16:17:04 +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: <200305041617.04998.mallah@trade-india.com>
X-Spam-Status: No, hits=-33.7 required=5.0
	tests=BAYES_01,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT,
	QUOTE_TWICE_1,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/47
X-Sequence-Number: 13212

On Friday 02 May 2003 8:46 pm, Tom Lane wrote:
> Rajesh Kumar Mallah <mallah@trade-india.com> 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?


Tom 

Do i have to only change POS(8) to POS(22)
in line below in datetime.c ?

 {"ist", TZ, POS(8)},            /* Israel */

so that IST is interpreted as Indian Time Zone?

so some other places too ?


Regds
mallah.



>
> 			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.