How to get number of days between two dates using MySQL
While developing web application , in many many places we face the problem where we can use only MYSQL and get the number of number of days between two given dates using MySQL.
Syntax – DATEDIFF(FirstDate,SecondDate)
This function will calculate the difference bretween two dates and give the out put in number of days. It will give the result positive only if first date is grater than second date. If Second date is greater than First date than it will give the negative result.
Query : SELECT DATEDIFF('2010-01-05', '2009-12-15');
Result : 21
Query : SELECT DATEDIFF('2009-12-15', '2010-01-05');
Result : -21
Look at below links for great magic tricks.
To know more about programming ,MYSQL database , php info , php editor , programming php ,Open-source, php help and php script , subscribe to our feed by entering email address below. You will get updates via email about every tutorial posted on this site . It will not take more than a sec.