: 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.
>
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
>
> --
nt: Monday, 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
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
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.
&
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 i
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
--
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/
