How can we know the number of days between two given dates using MySQL? Sudheesh.R Use DATEDIFF() SELECT DATEDIFF(NOW(),’2006-07-01′);