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 2D55C52879 for ; Mon, 23 May 2005 07:10:26 -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 28349-05 for ; Mon, 23 May 2005 10:10:23 +0000 (GMT) Received: from snchnm01.scandentgroup.com (mail.scandentgroup.com [203.101.64.100]) by svr1.postgresql.org (Postfix) with SMTP id 543FE52864 for ; Mon, 23 May 2005 07:10:16 -0300 (ADT) Subject: Need 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 15:22:02 +0530 X-MIMETrack: Serialize by Router on SNCHNM01/Scandent(Release 6.5|September 26, 2003) at 05/23/2005 03:32:53 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=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200505/182 X-Sequence-Number: 21495 how can retrieve rows where the datedifference is more than 30... assume there exists a field named 'datacreated' which is of type 'date'. I need to compare it with the current date and need to extract the matched rows.... thanks in advance. Palanivel 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.