Re: timeofday() and now() issue..

From: Rajesh Kumar Mallah <mallah(at)trade-india(dot)com>
To: "A(dot)Bhuvaneswaran" <bhuvansql(at)myrealbox(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, <pgsql-sql(at)postgresql(dot)org>
Subject: Re: timeofday() and now() issue..
Date: 2003-05-03 07:32:04
Message-ID: 200305031302.04198.mallah@trade-india.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


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.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message pginfo 2003-05-03 09:12:22 problem with max and not using index on PK
Previous Message A.Bhuvaneswaran 2003-05-03 05:13:45 Re: timeofday() and now() issue..