figuring out number of months between two dates
| From: | John Hughes | Date: | Tue, 02 Apr 2002 07:56:02 +0000 |
| Subject: | figuring out number of months between two dates | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-18112@lists.php.net to get a copy of this message | ||
I have a table that contains a list of dates. For instance:
2001-08-23
2001-08-27
2001-09-04
(and running through)
2002-06-03
I want to calculate how many months between 2001-08-23 and CURRENT_DATE
(which for discussion purposes we'll put at 2002-04-01) and how many months
between the first week and the last.
I can count the weeks and divide by 4.333 to approximate months, but I was
wondering if there was a way to use a PHP function or MySQL's MONTH() to do
the job.