Re: Time problem

"Jaya Swarup" <jayas@bsil.com> writes:
> 3) BUT, when I am retrieving data from the sql query (code) and displaying
> it, it is inexplicably ahead of the System time by exactly 30 mins.

Sure sounds like you are running in some odd time zone.

> 4) I have tried setting the TIME ZONE variable to all possible combinations
> as mentioned in the documentation. But even then if I ask the system to SHOW
> TIME ZONE, it says "TIME ZONE IS UNKNOWN".

This is bizarre.  Exactly what platform are you running on, and exactly
which "possible combinations" have you tried?

            regards, tom lane