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

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()  年月日