sql时间筛选date between and 获取未来第几天日期

and cce.start_time between #{param.startTime} and #{param.endTime}

具体需求：求未来几天内的数据，例如未来3天内的数据，如下方法获取3天后的日期，用between and 筛选

/**
     * 获取未来 第 past 天的日期
     * @param past
     * @return
     */
    public static Date getFetureDate(int past) {
        Calendar calendar = Calendar.getInstance();
        calendar.set(Calendar.DAY_OF_YEAR, calendar.get(Calendar.DAY_OF_YEAR) + past);
        Date today = calendar.getTime();
        return today;
    }