query

From: "Chandan_Kumaraiah" <Chandan_Kumaraiah(at)satyam(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: query
Date: 2005-03-17 10:57:34
Message-ID: 2EB549AAAFEA264FA926269A5BD5E9EB146577@certsrv.satyam.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,

In oracle we write sysdate-1

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

Chandan

Responses

  • Re: query at 2005-03-21 14:33:43 from Thomas F.O'Connell

Browse pgsql-sql by date

  From Date Subject
Next Message Chandan_Kumaraiah 2005-03-17 11:08:15 query
Previous Message Tambet Matiisen 2005-03-17 08:39:43 Re: How to force subquery scan?