MySQL DATEDIFF Return the difference in days between two date values: SELECT DATEDIFF("2017-06-25", "2017-06-15"); // 10