postgresql7.1 where now()-o.confirmed_date <= timespan_days(1) where now()-o.confirmed_date <= timespan_days(7) where now()-o.confirmed_date <= '1 month'::interval