java和mysql计算两个时间的天数

一、Java计算


 Date end_time=......;


 Date start_time=......;
 
double day=(end_time.getTime()-start_time.getTime())/(1000*60*60*24)；


二、mysql中计算


SELECT ...,...,
IF(DATEDIFF(create_stage_date,start_date) IS NULL,NULL,DATEDIFF(end_time,start_time)+1) AS Day
FROM ...
WHERE ...