如何从mysql中的当前日期时间中减去30天?

分类: 技术问答 • 2022-06-03 13:51:12

问题描述：

如何在mysql中从当前日期时间减去30天?

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();

答

SELECT * FROM table
WHERE exec_datetime BETWEEN DATE_SUB(NOW(), INTERVAL 30 DAY) AND NOW();