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
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
Really?
MONTH(date)
Returns the month for date, in the range 1 to 12:
mysql SELECT MONTH('1998-02-03');
- 2
There're other functions that will also be useful tools for you to achieve what
I can only guess is your goal. I can think of 10 ways off-hand to solve your
, 24 June 2002 5:30 pm
To: D.K.Dubey; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: get months between two dates
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
Use the month(date) function.
select month(firstDate) - month(secondDate) from someTable where ...;
Hope this helps.
Frank
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
: Re: get months between two dates
Use the month(date) function.
select month(firstDate) - month(secondDate) from someTable where ...;
Hope this helps.
Frank
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
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
--
