java和mysql中分别计算时间差（天数）

Date currentTime=new Date();
				long diff = record.getApproveTime().getTime() - currentTime.getTime();//这样得到的差值是微秒级别
				if( diff / (1000 * 60 * 60 * 24) >=15) {

参考：

java：
Date expectedFinishTime=sdf.parse(planTask.getTaskfinishtime());
Date currentTime=new Date();
long diff = expectedFinishTime.getTime() - currentTime.getTime();//这样得到的差值是微秒级别
long days = diff / (1000 * 60 * 60 * 24);

mysql:
DATEDIFF(TaskFinishTime,now())
now()获取当前时间  年月日：时分秒
current_time()  时分秒
current_date()