Rajesh Kumar Mallah <mallah(at)trade-india(dot)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