public static String removeDigits(String input) {
        if (StringUtils.isBlank(input)) {
            return input;
        }
        return input.replaceAll("\\(\\d+\\)", "");
    }
String input = "INTERVAL DAY(2) TO SECOND(6)";
remove (2) and (6)

@param input
@return
chat2db-server/chat2db-spi/src/main/java/ai/chat2db/spi/util/SqlUtils.java