Received: from mailo.vtcif.telstra.com.au (mailo.vtcif.telstra.com.au [202.12.144.17]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA09826 for ; Wed, 24 May 2000 20:07:36 -0400 (EDT) (envelope-from chrisb@nimrod.itg.telstra.com.au) Received: (from uucp@localhost) by mailo.vtcif.telstra.com.au (8.8.2/8.6.9) id KAA16937; Thu, 25 May 2000 10:07:04 +1000 (EST) Received: from maili.vtcif.telstra.com.au(202.12.142.17) via SMTP by mailo.vtcif.telstra.com.au, id smtpd0s.NgI; Thu May 25 10:06:34 2000 Received: (from uucp@localhost) by maili.vtcif.telstra.com.au (8.8.2/8.6.9) id KAA11661; Thu, 25 May 2000 10:06:33 +1000 (EST) Received: from localhost(127.0.0.1), claiming to be "mail.cdn.telstra.com.au" via SMTP by localhost, id smtpd0uQJLZ; Thu May 25 10:05:42 2000 Received: from lunitari.nimrod.itg.telecom.com.au (lunitari.nimrod.itg.telecom.com.au [192.53.254.48]) by mail.cdn.telstra.com.au (8.8.2/8.6.9) with ESMTP id KAA04772; Thu, 25 May 2000 10:05:42 +1000 (EST) Received: from nimrod.itg.telecom.com.au (majere [192.53.254.45]) by lunitari.nimrod.itg.telecom.com.au (8.9.1/8.9.3) with ESMTP id KAA07872; Thu, 25 May 2000 10:04:21 +1000 (EST) Message-ID: <392C6D9D.C53C104B@nimrod.itg.telecom.com.au> Date: Thu, 25 May 2000 10:02:37 +1000 From: Chris Bitmead Organization: IBM Global Services X-Mailer: Mozilla 4.6 [en] (X11; I; SunOS 5.6 sun4u) X-Accept-Language: en MIME-Version: 1.0 To: gomathi raju CC: pgsql-novice@postgresql.org Subject: Re: [HACKERS] References: <20000524213727.2025.qmail@nwcst279.netaddress.usa.net> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/26 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. Are you talking about SELECT 'now' ?