select month(current_date)-month(fild_name) from database where your_critteria
This should show you the months between the current date and the date contained in the fild_name ----- Original Message ----- From: "D.K.Dubey" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> Sent: Monday, June 24, 2002 10:23 AM Subject: RE: get months between two dates > 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 > --------------------------------------------------------------------- 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