Hi Van, I read that before sending u the query. In that no where is mention to subtract the dates and finding the no months between dates.
D K Dubey -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Van Sent: Monday, June 24, 2002 11:43 AM To: D.K.Dubey Cc: [EMAIL PROTECTED] Subject: Re: get months between two dates Consider taking a look at the manual: http://www.mysql.com/doc/D/a/Date_and_time_functions.html Perhaps read parts of it, too. Fix your PC's date (the current year for most of us is 2002). Many of us who receive e-mail dated in the past filter it to /dev/null. Van -- ================================================================= Linux rocks!!! http://www.dedserius.com/ ================================================================= "D.K.Dubey" wrote: > > Hi, Can anybody tell me how i can calculate the months between two dates in > mysql. > thanks in advance > Regards > D K Dubey > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php