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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
