[SQL] query

[Chandan_Kumaraiah]

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