Re: How do we get the Client-Time and Server-Time from psql ? - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: How do we get the Client-Time and Server-Time from psql ?
Date
Msg-id 4C062ACA.7010705@iol.ie
Whole thread Raw
In response to How do we get the Client-Time and Server-Time from psql ?  (raghavendra t <raagavendra.rao@gmail.com>)
List pgsql-general
On 02/06/2010 10:48, 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 ?

I don't think you can, from within a query anyway - it's always going to
run on the server side. You'll have to do it from within your application.

Ray.

--
Raymond O'Donnell :: Galway :: Ireland
rod@iol.ie

pgsql-general by date:

Previous
From: raghavendra t
Date:
Subject: How do we get the Client-Time and Server-Time from psql ?
Next
From: Ivan Voras
Date:
Subject: tsearch2 & dictionaries - possible problem