Organizational Research By

Surprising Reserch Topic

how to subtract 30 days from the current datetime in mysql using -'mysql'


how to subtract 30 days from the current datetime in mysql  using -'mysql'

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

    

asked Sep 7, 2015 by rajesh
0 votes
4 views



Related Hot Questions

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.
Anti-spam verification:
To avoid this verification in future, please log in or register.

...