"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