SELECT productid FROM product
WHERE purchase_date ?

SELECT productid FROM product WHERE purchase_date > sysdate-30