时间戳转化为Date
int i=1300527197;
SimpleDateFormat sdf=new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
String time=sdf.format(new Date(i*1000L));
select round(sysdate-t.dateline,0),sysdate-t.dateline,t.dateline from dy_change_goods t where round(sysdate-t.dateline,0)<=5
时间比较大小
Date date1 = new Date();
DateFormat df = DateFormat.getDateTimeInstance();
date1.before(df.parse(date2));
得到几天后的时间
String endTime="";
import java.text.SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
Date dateStart=sdf.parse(startTime);
Calendar now = Calendar.getInstance();
now.setTime(dateStart);
now.set(Calendar.DATE, now.get(Calendar.DATE) + day);
endTime=sdf.format(now.getTime());