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 3934956A13 for ; Thu, 17 Mar 2005 11:08:38 +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 86800-09 for ; Thu, 17 Mar 2005 11:08:29 +0000 (GMT) Received: from vvamail.satyam.com (vvamail.satyam.com [208.220.247.17]) by svr1.postgresql.org (Postfix) with ESMTP id 8896156A12 for ; Thu, 17 Mar 2005 11:08:28 +0000 (GMT) Received: from che1.satyam.com (che1.satyam.com [172.18.73.11]) by vvamail.satyam.com (8.11.6/8.11.6) with ESMTP id j2HAngR10272 for ; Thu, 17 Mar 2005 05:49:43 -0500 Received: from cscmsg002.corp.satyam.ad (localhost [127.0.0.1]) by che1.satyam.com (8.11.6/8.11.6) with ESMTP id j2HB3LE11215 for ; Thu, 17 Mar 2005 16:33:21 +0530 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C52AE1.9DC1D91B" Subject: query Date: Thu, 17 Mar 2005 16:38:15 +0530 Message-ID: <2EB549AAAFEA264FA926269A5BD5E9EB146579@certsrv.satyam.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: query Thread-Index: AcUq4BXnHuFTr8odT7SBiZ4aa7so0gAAVvew From: "Chandan_Kumaraiah" To: X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.15 tagged_above=0 required=5 tests=AWL, HTML_90_100, HTML_MESSAGE X-Spam-Level: * X-Archive-Number: 200503/235 X-Sequence-Number: 20714 This is a multi-part message in MIME format. ------_=_NextPart_001_01C52AE1.9DC1D91B Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable =20 Hi, =20 In oracle we write sysdate-1 For example,we write a query (select * from table1 where created_date>=3Dsysdate-1).Whats its equivalent in postgre? =20 Chandan =20 ------_=_NextPart_001_01C52AE1.9DC1D91B Content-Type: text/html; charset="us-ascii" Content-Transfer-Encoding: quoted-printable

Hi,

<= /p>

In oracle we write = sysdate-1

For example,we write a query = (select * from table1 where created_date>=3Dsysdate-1).Whats its equivalent in = postgre?

<= /p>

Chandan=

<= /p>

------_=_NextPart_001_01C52AE1.9DC1D91B--