John R Pierce <pierce@hogranch.com> writes:
> deepthi@granwill.com wrote:
>> How can i convert this time or get the corresponding
>> time at US using pgsql time zone feature or if anything else.
> store GMT in the database always, convert back to local time when you
> display it.
Note that the TIMESTAMP WITH TIME ZONE datatype effectively does that
for you. The only thing you need to do is SET TIMEZONE to the
appropriate timezone for data entry or display. The server's timezone
is really entirely irrelevant, except that it sets the initial default
value for the TIMEZONE setting.
regards, tom lane