sql实现:Oracle实现
select to_char(sysdate, 'YYYYMM') as nowDate,
to_char(add_months(sysdate, 1), 'YYYYMM') nextDate,
to_char(add_months(sysdate, 2), 'YYYYMM') SecondDate
from dual;
Java实现:
/**
* 获取下个月
* @param date
* @return
*/
private static Date getLastDate(Date date) {
Calendar cal = Calendar.getInstance();
cal.setTime(date);
cal.add(Calendar.MONTH, +1);
return cal.getTime();
}
调用Java程序:
SimpleDateFormat sdf = new SimpleDateFormat("yyyyMM");
System.out.println(sdf.format(new Date()));
System.out.println(sdf.format(getLastDate(new Date())));