The TIMESTAMPADD function is part of the ODBC/JDBC standard and is supported by H2, MySQL. So try to use this, Hope this will solve your problem

SELECT TIMESTAMPADD(DAY, -30, CURRENT_DATE());