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
