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

From: Raymond O'Donnell <rod(at)iol(dot)ie>
To: raghavendra t <raagavendra(dot)rao(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: How do we get the Client-Time and Server-Time from psql ?
Date: 2010-06-02 09:56:26
Message-ID: 4C062ACA.7010705@iol.ie
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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(at)iol(dot)ie

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ivan Voras 2010-06-02 10:42:22 tsearch2 & dictionaries - possible problem
Previous Message raghavendra t 2010-06-02 09:48:20 How do we get the Client-Time and Server-Time from psql ?