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

Raymond O'Donnell <rod@iol.ie>

From: Raymond O'Donnell <rod@iol.ie>
To: raghavendra t <raagavendra.rao@gmail.com>
Cc: pgsql-general@postgresql.org
Date: 2010-06-02T09:56:26Z
Lists: 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