加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(); }}