"Jaya Swarup" <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
