MySQL Forums
Forum List  »  MySQL Query Browser

How to find Month Difference of two given dates
Posted by: Syam lal
Date: October 10, 2012 02:23PM

Can anybody tell me how could I get the MONTH Difference of two given dates? In fact, period_diff will not work at all!!!

Ex. date1 = '2009-05-30' & date2 = '2009-06-05'

We all know that the answer is 0, but how to get it using Query in MySQL???

Any help would be appreciated?

Syam

Options: ReplyQuote


Subject
Written By
Posted
How to find Month Difference of two given dates
October 10, 2012 02:23PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.