Re: How do we get the Client-Time and Server-Time from psql ?

On 06/02/2010 02:48 AM, raghavendra t wrote:
> Hi All,
>
> How do i get the client time and server time. I am connecting
> remotely. If i give SELECT CURRENT_TIME;,it shows the server time. How
> do we get the client time ?
>
Time is the same everywhere but displayed in different ways according to
local time-zones. In order to deal with non-synchronized clients or
server-side specific values like differentiating between CURRENT_TIME
which returns the time at start of transaction throughout the life of
the transaction and timeofday() which _does_ change throughout a
transaction you should use "SET TIMEZONE". For example my server is on
the West Coast but I can display time for East Coasters:

steve=# show timezone;
TimeZone
-----------
localtime

steve=# select current_time;
timetz
--------------------
11:06:14.745969-07

steve=# set timezone to 'est5edt';
SET
steve=# show timezone;
TimeZone
----------
EST5EDT

steve=# select current_time;
timetz
--------------------
14:06:29.456009-04

Cheers,
Steve