Received: from henry.newn.cam.ac.uk (henry.newn.cam.ac.uk [131.111.204.130]) by hub.org (8.9.3/8.9.3) with ESMTP id SAA45268 for ; Wed, 24 May 2000 18:40:57 -0400 (EDT) (envelope-from prlw1@newn.cam.ac.uk) Received: from [131.111.204.180] (helo=quartz.newn.cam.ac.uk) by henry.newn.cam.ac.uk with esmtp (Exim 3.13 #1) id 12ujpx-0005IZ-00; Wed, 24 May 2000 23:41:13 +0100 Received: from prlw1 by quartz.newn.cam.ac.uk with local (Exim 3.13 #1) id 12ujph-0005qz-00; Wed, 24 May 2000 23:40:57 +0100 Date: Wed, 24 May 2000 23:40:57 +0100 From: Patrick Welche To: gomathi raju Cc: pgsql-novice@postgresql.org Subject: Re: [HACKERS] Message-ID: <20000524234057.A22396@quartz.newn.cam.ac.uk> Reply-To: prlw1@cam.ac.uk References: <20000524213727.2025.qmail@nwcst279.netaddress.usa.net> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii User-Agent: Mutt/1.1.1i In-Reply-To: <20000524213727.2025.qmail@nwcst279.netaddress.usa.net>; from gomathi_raju@usa.net on Mon, Jun 30, 2036 at 10:05:43PM -0600 X-Archive-Number: 200005/25 On Mon, Jun 30, 2036 at 10:05:43PM -0600, gomathi raju wrote: > Hi friends, > > I want to get the system timestamp from postgresql database. > But I dont have a dual table from where ,I can select it. > Give me a solution, from which table(system) I can get it. Could this be what you want? template1=# select CURRENT_TIMESTAMP; timestamp ------------------------ 2000-05-24 23:40:19+01 Cheers, Patrick