LMSouq
database Open

How to subtract 30 days from the current datetime in mysql?

US
user784637
1 month ago
3 views
Problem Description
How do I subtract 30 days from the current datetime in mysql? SELECT * FROM table WHERE exec_datetime BETWEEN DATEDIFF(NOW() - 30 days) AND NOW();

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base