Mysql Select where time difference between columns date

Question

How to query by selecting rows where time difference between columns date greater than X days

ID            Date1                        Date2
1             2017-02-01T00:00:00          2017-02-15T00:00:00

Note: Time stored in 2017-02-15T00:00:00 format.

I tried this

WHERE TIMEDIFF(DAY, Date1, Date2) > 1

Answer 1

Use DATEDIFF()

WHERE ABS(DATEDIFF(date1, date2)) > 1