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

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?
        regards, tom lane