Pre Exam Test Practice (SSC | Banking | IAS | GATE | State Level | CLAT | Railways | Insurance | Teaching Exams | NDA | Defence | IES |State Exam )

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



Government Jobs Opening


...