Hi All,
Thank you for the update.
Suppose am at the server-end, how could i get the client-time. Its really troublesome when compared with the timezone column in a table.
Regards
Raghavendra
On Wed, Jun 2, 2010 at 11:37 PM, Steve Crawford <scrawford@xxxxxxxxxxxxxxxxxxxx> wrote:
On 06/02/2010 02:48 AM, raghavendra t wrote: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:
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 ?
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
