X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id D3DF3475F16
	for <pgsql-sql@postgresql.org>; Sat,  3 May 2003 03:32:33 -0400 (EDT)
Received: from rtlocal.trade-india.com (unknown [203.196.129.235])
	by postgresql.org (Postfix) with SMTP id 0A1F4475A80
	for <pgsql-sql@postgresql.org>; Sat,  3 May 2003 03:32:10 -0400 (EDT)
Received: (qmail 8097 invoked from network); 3 May 2003 07:33:07 -0000
Received: from unknown (HELO system67.trade-india-local.com) (unknown)
	by unknown with SMTP; 3 May 2003 07:33:07 -0000
From: Rajesh Kumar Mallah <mallah@trade-india.com>
Organization: Infocom Network Limited
To: "A.Bhuvaneswaran" <bhuvansql@myrealbox.com>
Subject: Re: timeofday() and now() issue..
Date: Sat, 3 May 2003 13:02:04 +0530
User-Agent: KMail/1.5
Cc: Tom Lane <tgl@sss.pgh.pa.us>, <pgsql-sql@postgresql.org>
References: <Pine.LNX.4.44.0305031041500.2010-100000@Bhuvan.bksys.co.in>
In-Reply-To: <Pine.LNX.4.44.0305031041500.2010-100000@Bhuvan.bksys.co.in>
MIME-Version: 1.0
Content-Type: text/plain;
  charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
Message-Id: <200305031302.04198.mallah@trade-india.com>
X-Spam-Status: No, hits=-32.3 required=5.0
	tests=BAYES_10,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/43
X-Sequence-Number: 13208


Dear Tom,

Can you please tell us if its something 
to be fixed in PostgreSQL or in our systems
configurations ?

Becoz this probelm will keep hauting all
ppl who have set their Tz to Indian Standard Time.

Btw Is there no international standard on it?

Regds
Mallah.

On Saturday 03 May 2003 10:43 am, A.Bhuvaneswaran wrote:
> > 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.ht
> >ml
>
> Finally, what is the conclusion? Can't we use timeofday in IST, indian
> standard time (+5:30)?
>
> regards,
> bhuvaneswaran

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