how to get 30 days after a date in sql code example

Example: get data every 30 days in sql

SELECT * FROM product 
WHERE pdate BETWEEN datetime('now', '-30 days') AND datetime('now', 'localtime')