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