query

From: "Chandan_Kumaraiah" <Chandan_Kumaraiah(at)satyam(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: query
Date: 2005-03-17 11:08:15
Message-ID: 2EB549AAAFEA264FA926269A5BD5E9EB146579@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-17 11:43:29 from Terry Fielder

Browse pgsql-sql by date

  From Date Subject
Next Message PFC 2005-03-17 11:20:16 Re: Query performance problem
Previous Message Chandan_Kumaraiah 2005-03-17 10:57:34 query