SELECT
start_date+length,
ABS(DATEDIFF(STR_TO_DATE(concat(start_date,' ',ifnull(start_time,'')),'%Y-%m-%d %H:%i:%s'),now())),
calendar0_.*
FROM
personal_calendar calendar0_
WHERE
calendar0_.user_id =1
and ABS(DATEDIFF(STR_TO_DATE(concat(start_date,' ',ifnull(start_time,'')),'%Y-%m-%d %H:%i:%s'),now()))<=1