update User_Package set endtime=dateadd(day,30,endtime) where endtime>='2010-8-1' and endtime<'2010-9-1' 转载于:https://www.cnblogs.com/laoqiang/archive/2010/08/19/1803369.html