加n 天

1.

在数据库中：参数d 为 day,还有M、y等

select convert(varchar(10),dateadd(d,n,'2008-12-31'),120)

2.在java 程序中:

public static void main(String[] args) {

String createDate = "2008-12-01";

SimpleDateFormat sdf = new SimpleDateFormat("yyyy-mm-dd");

try {

Date date = sdf.parse(createDate);

Calendar cl = Calendar.getInstance();

cl.setTime(date);

cl.add(Calendar.DATE,1);

String temp = "";

temp = sdf.format(cl.getTime());

System.out.println(temp);

} catch (ParseException e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

}