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@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general