SyntaxFix
Write A Post
Hire A Developer
Questions
This Should Work Fine
SELECT * FROM product WHERE pdate BETWEEN datetime('now', '-30 days') AND datetime('now', 'localtime')