date

--明天
    SELECT trunc(v_begin_date_t + 1,'DDD') INTO v_begin_date FROM dual;
    SELECT trunc(v_end_date_t + 1,'DDD') INTO v_end_date FROM dual;
--下个月
    SELECT trunc(add_months(v_begin_date_t, +1), 'mm') INTO v_begin_date FROM dual;
    SELECT trunc(LAST_DAY(add_months(v_end_date_t, +1)),'DDD')  INTO v_end_date FROM dual;
--下季度
    SELECT trunc(add_months(v_begin_date_t, +3), 'mm') INTO v_begin_date FROM dual;
    SELECT add_months(v_end_date_t, +3) INTO v_end_date FROM dual;
--明年
    SELECT trunc(add_months(v_begin_date_t, +12), 'yyyy') INTO v_begin_date FROM dual;
    SELECT add_months(v_end_date_t, +12) INTO v_end_date FROM dual;