TIMESTAMPDIFF(year,p.birthdate,CURDATE()) as year,
timestampdiff(month,p.birthdate,curdate())-(timestampdiff(year,p.birthdate,curdate())*12) as count_month,
timestampdiff(day,date_add(p.birthdate,interval (timestampdiff(month,p.birthdate,curdate())) month),curdate()) as count_day,
ไม่มีความคิดเห็น:
แสดงความคิดเห็น