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 E939456580 for ; Mon, 21 Mar 2005 14:34:03 +0000 (GMT) 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 07311-09 for ; Mon, 21 Mar 2005 14:33:41 +0000 (GMT) Received: from window.monsterlabs.com (window.monsterlabs.com [216.183.105.176]) by svr1.postgresql.org (Postfix) with SMTP id 828B656467 for ; Mon, 21 Mar 2005 14:33:39 +0000 (GMT) Received: (qmail 507 invoked from network); 21 Mar 2005 14:33:43 -0000 Received: from a202088.n1.vanderbilt.edu (HELO ?129.59.202.88?) (129.59.202.88) by 0 with SMTP; 21 Mar 2005 14:33:43 -0000 In-Reply-To: <2EB549AAAFEA264FA926269A5BD5E9EB146577@certsrv.satyam.com> References: <2EB549AAAFEA264FA926269A5BD5E9EB146577@certsrv.satyam.com> Mime-Version: 1.0 (Apple Message framework v619.2) Content-Type: text/plain; charset=ISO-8859-1; format=flowed Message-Id: Content-Transfer-Encoding: quoted-printable Cc: From: Thomas F.O'Connell Subject: Re: query Date: Mon, 21 Mar 2005 08:33:43 -0600 To: "Chandan_Kumaraiah" X-Mailer: Apple Mail (2.619.2) X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/285 X-Sequence-Number: 20764 You should be able to use the CURRENT_DATE function in place of sysdate. You might need to cast the 1 explicitly to an interval. As in: CURRENT_DATE - '1 day'::interval -tfo -- Thomas F. O'Connell Co-Founder, Information Architect Sitening, LLC http://www.sitening.com/ 110 30th Avenue North, Suite 6 Nashville, TN 37203-6320 615-260-0005 On Mar 17, 2005, at 4:57 AM, Chandan_Kumaraiah wrote: > Hi,=A0 > > In oracle we write sysdate-1 > > For example,we write a query (select * from table1 where=20 > created_date>=3Dsysdate-1).Whats its equivalent in postgre? > > Chandan