Postgres Pro
Downloads
Home   >   mailing lists

Thread: Time conversion across various parts of world

Time conversion across various parts of world

From
deepthi@granwill.com
Date:
Hello,

For example, our website is running on a server located in Japan and we have
another website #2 running in US. our database is located on the server in
Japan. when some one accesses our website #2 which is located in US, the time
at which the user accessed our website #2 has to be registered in a database
which is situated in Japan. but at present i am getting the system time of the
server which is in japan.  How can i convert this time or get the corresponding
time at US using pgsql time zone feature or if anything else.

Please note: Our other website#2 can be located in other parts of the world
also, it need not be US only. I have the country name where our  website#2 is
located and by using this name i need to get the time in that country.

we are using postgresql 7.3.4.

Eagerly waiting for replies.

Thanking you,
deepthi

Re: Time conversion across various parts of world

From
John R Pierce
Date:
deepthi@granwill.com wrote:
> Hello,
>
> For example, our website is running on a server located in Japan and we have
> another website #2 running in US. our database is located on the server in
> Japan. when some one accesses our website #2 which is located in US, the time
> at which the user accessed our website #2 has to be registered in a database
> which is situated in Japan. but at present i am getting the system time of the
> server which is in japan.  How can i convert this time or get the corresponding
> time at US using pgsql time zone feature or if anything else.
>
> Please note: Our other website#2 can be located in other parts of the world
> also, it need not be US only. I have the country name where our  website#2 is
> located and by using this name i need to get the time in that country.

store GMT in the database always, convert back to local time when you display it.

Re: Time conversion across various parts of world

From
Tom Lane
Date:
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