MySQL：获取行添加x小时

Question

Fetch rows for the past x hours. The problem is that x can be any amount of hours.For instance if x is 48, I need to get all the rows for the past 2 days. How can I store the datetime in the database and successfully retrieve the rows. Thank you. The user will select a date and time, then the duration(x).

Answer 1

You may use DATE_SUB() function in mysql.

    *** WHERE `timecolumn_in_your_table` BETWEEN  ( DATE_SUB( '2016-08-17', INTERVAL 48 HOUR ) )  and '2016-08-17'

conditions can be given as per your requirement