获取两个日期之间月份数的优雅方法? [英] Elegant way to get the count of months between two dates?

问题描述

假设我在变量中有两个日期，例如

Let's assume I have two dates in variables, like

$date1 = "2009-09-01";
$date2 = "2010-05-01";

我需要获取$date2 和$date1($date2 >= $date1) 之间的月数.IE.我需要获得 8.

I need to get the count of months between $date2 and $date1($date2 >= $date1). I.e. i need to get 8.

有没有办法通过使用 date 函数来获取它，或者我必须分解我的字符串并进行所需的计算?

Is there a way to get it by using date function, or I have to explode my strings and do required calculations?

谢谢.

推荐答案

对于 PHP >= 5.3

For PHP >= 5.3

$d1 = new DateTime("2009-09-01");
$d2 = new DateTime("2010-05-01");

var_dump($d1->diff($d2)->m); // int(4)
var_dump($d1->diff($d2)->m + ($d1->diff($d2)->y*12)); // int(8)

DateTime::diff 返回一个 DateInterval 对象

DateTime::diff returns a DateInterval object

如果您不使用 PHP 5.3 或更高版本，我想您将不得不使用 unix 时间戳:

If you don't run with PHP 5.3 or higher, I guess you'll have to use unix timestamps :

$d1 = "2009-09-01";
$d2 = "2010-05-01";

echo (int)abs((strtotime($d1) - strtotime($d2))/(60*60*24*30)); // 8

但这不是很精确(每个月并不总是 30 天).

But it's not very precise (there isn't always 30 days per month).

最后一件事:如果这些日期来自您的数据库，那么使用您的 DBMS 来完成这项工作，而不是 PHP.

Last thing : if those dates come from your database, then use your DBMS to do this job, not PHP.

如果您不能使用 DateTime::diff 或您的 RDBMS，此代码应该更精确:

This code should be more precise if you can't use DateTime::diff or your RDBMS :

$d1 = strtotime("2009-09-01");
$d2 = strtotime("2010-05-01");
$min_date = min($d1, $d2);
$max_date = max($d1, $d2);
$i = 0;

while (($min_date = strtotime("+1 MONTH", $min_date)) <= $max_date) {
    $i++;
}
echo $i; // 8

这篇关于获取两个日期之间月份数的优雅方法?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！