mysql datediff 30 days code example

Example 1: mysql datediff days

#Get date diff in days
select DATEDIFF('2020-04-13', '2020-04-20');#returns -7
select DATEDIFF('2020-04-20', '2020-04-13');#returns  7

Example 2: mysql date equals to current_date plus days

SELECT CURRENT_DATE - INTERVAL 30 DAY