Received: from rly-ip02.mx.aol.com (rly-ip02.mx.aol.com [152.163.225.160]) by hub.org (8.9.3/8.9.3) with ESMTP id MAA24547 for ; Thu, 25 May 2000 12:32:13 -0400 (EDT) (envelope-from mmayo@mcauleybrooklyn.org) Received: from tot-tp.proxy.aol.com (tot-tp.proxy.aol.com [152.163.204.131]) by rly-ip02.mx.aol.com (8.8.8/8.8.8/AOL-5.0.0) with ESMTP id MAA18584; Thu, 25 May 2000 12:31:08 -0400 (EDT) Received: from 362197428 (98A7001A.ipt.aol.com [152.167.0.26]) by tot-tp.proxy.aol.com (8.10.0/8.10.0) with ESMTP id e4PGV6329368; Thu, 25 May 2000 12:31:06 -0400 (EDT) Message-ID: <004a01bfc666$04f51e40$1ce8b798@362197428> From: "Michael A. Mayo" To: "gomathi raju" , References: <20000524213727.2025.qmail@nwcst279.netaddress.usa.net> Subject: Re: [SQL] Date: Thu, 25 May 2000 00:54:38 -0400 Organization: Brooklyn College MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6600 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 X-Apparently-From: PerlWebGuy@aol.com X-Archive-Number: 200005/28 ----- Original Message ----- From: "gomathi raju" > 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. No need to get it from a system table; it is available as a sort of "global constant," current_timestamp. Use it like this: SELECT CURRENT_TIMESTAMP; See the book at: http://www.postgresql.org/docs/awbook.html for more information. -Mike