CODE EXAMPLE FOR SQL

get data every 30 days in sql

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