how to decrease month in now() mariadb code example Example: mariadb date equals to current_date plus days SELECT CURRENT_DATE - INTERVAL 30 DAY