Terry Fielder wrote:
now() returns a timestamp.
Cast it to a date and then you can subtract days. e.g.
select now()::date -1
Or CURRENT_DATE - 1
*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?*
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
