date difference should be multiple of 30 days in mysql'\ code example Example: mysql date equals to current_date plus days SELECT CURRENT_DATE - INTERVAL 30 DAY