Dates

时间戳转化为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());