X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CB0BC5287C for ; Mon, 23 May 2005 08:06:36 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 38887-06 for ; Mon, 23 May 2005 11:06:33 +0000 (GMT) Received: from snchnm01.scandentgroup.com (mail.scandentgroup.com [203.101.64.100]) by svr1.postgresql.org (Postfix) with SMTP id 3CA6C52876 for ; Mon, 23 May 2005 08:06:31 -0300 (ADT) Subject: need date clarification To: pgsql-sql@postgresql.org X-Mailer: Lotus Notes Release 5.0.8 June 18, 2001 Message-ID: From: palanivel.kumaran@scandent.com Date: Mon, 23 May 2005 16:26:23 +0530 X-MIMETrack: Serialize by Router on SNCHNM01/Scandent(Release 6.5|September 26, 2003) at 05/23/2005 04:29:04 PM MIME-Version: 1.0 Content-type: text/plain; charset=US-ASCII X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.178 tagged_above=0 required=5 tests=AWL, NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200505/185 X-Sequence-Number: 21498 how can i extract the system date in postgress. Thanks & Regards Palanivel P.K Important Email Information :- The information in this email is confidential and may be legally privileged. It is intended solely for the addressee. Access to this email by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. If you are not the intended addressee please contact the sender and dispose of this e-mail immediately.