Request a Demo
Home   >   mailing lists

query - Mailing list pgsql-sql

From Chandan_Kumaraiah
Subject query
Date
Msg-id 2EB549AAAFEA264FA926269A5BD5E9EB146577@certsrv.satyam.com
Whole thread Raw
Responses Re: query
List pgsql-sql
Tree view

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

 

pgsql-sql by date:

Previous
From: "mroyce@gmail.com"
Date:
Subject: timestamp precision - can I control precision at select time or set for all time?
Next
From: Jonathan Daugherty
Date:
Subject: Re: tablename as function parameter