blocks|key|296129|text|数据库中的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|296130|日期如下所示2011-10-2|blockquote|296131|296132|296133|将其存储在YYYY-MM-DD中，然后进行字符串比较，因为'1‘>+'0’等等。|296134|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$]]|$1|E|3|-4|5|6|7|M|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|N|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|P|8|@]|9|@]|A|$]]]|J|$]]

<blockquote>
 in the database the date looks like this 2011-10-2
</blockquote>

Store it in YYYY-MM-DD and then string comparison will work because '1' > '0', etc.

blocks|key|295407|text|如果你所有的日期都在1970年1月1日之后，你可以使用这样的东西：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|295408|$today+=+date("Y-m-d");
$expire+=+$row->expireDate;+//from+database

$today_time+=+strtotime($today);
$expire_time+=+strtotime($expire);

if+($expire_time+<+$today_time)+{+/*+do+Something+*/+}|code-block|syntax|javascript|295409|如果您使用的是PHP5+>=+5.2.0，则可以使用DateTime类：|295410|$today_dt+=+new+DateTime($today);
$expire_dt+=+new+DateTime($expire);

if+($expire_dt+<+$today_dt)+{+/*+Do+something+*/+}|295411|或者其他类似的东西。|295412|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|R|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|S|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|T|8|@]|9|@]|A|$]]]|N|$]]

If all your dates are posterior to the 1st of January of 1970, you could use something like:

<pre><code>$today = date("Y-m-d");
$expire = $row-&gt;expireDate; //from database

$today_time = strtotime($today);
$expire_time = strtotime($expire);

if ($expire_time &lt; $today_time) { /* do Something */ }
</code></pre>

If you are using PHP 5 >= 5.2.0, you could use the DateTime class:

<pre><code>$today_dt = new DateTime($today);
$expire_dt = new DateTime($expire);

if ($expire_dt &lt; $today_dt) { /* Do something */ }
</code></pre>

Or something along these lines.

blocks|key|295457|text|为了补充已经给出的答案，请参见以下示例：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|295458|$today+=+new+DateTime('');
$expireDate+=+new+DateTime($row->expireDate);+//from+database



if($today->format("Y-m-d")+<+$expireDate->format("Y-m-d"))+{+
++++//do+something;+
}|code-block|syntax|javascript|295459|更新：或简单地使用老式的date()函数：|offset|length|style|BOLD|295460|if(date('Y-m-d')+<+date('Y-m-d',+strtotime($expire_date))){
++++//echo+not+yet+expired!+
}+++|295461|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/function.date.php^0|0|0|0|3|C|6|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@$I|Z|J|10|K|L]]|9|@$I|11|J|12|1|13]]|A|$]]|$1|M|3|N|5|D|7|14|8|@]|9|@]|A|$E|F]]|$1|O|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

Just to compliment the already given answers, see the following example:

<pre><code>$today = new DateTime('');
$expireDate = new DateTime($row-&gt;expireDate); //from database



if($today-&gt;format("Y-m-d") &lt; $expireDate-&gt;format("Y-m-d")) { 
 //do something; 
}
</code></pre>

Update:
 Or simple use old-school <a href="http://php.net/manual/en/function.date.php" rel="noreferrer">date()</a> function:

<pre><code>if(date('Y-m-d') &lt; date('Y-m-d', strtotime($expire_date))){
 //echo not yet expired! 
} 
</code></pre>

blocks|key|296147|text|我不会用PHP这样做的。数据库应该知道今天是几号(例如，使用MySQL->NOW()+)，因此可以非常容易地在查询中进行比较并返回结果，这取决于所使用的日期类型|type|unstyled|depth|inlineStyleRanges|entityRanges|data|296148|SELECT+IF(expireDate+<+NOW(),TRUE,FALSE)+as+isExpired+FROM+tableName|code-block|syntax|javascript|296149|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I would'nt do this with PHP. 
A database should know, what day is today.( use MySQL->NOW() for example ), so it will be very easy to compare within the Query and return the result, without any problems depending on the used Date-Types

<pre><code>SELECT IF(expireDate &lt; NOW(),TRUE,FALSE) as isExpired FROM tableName
</code></pre>

blocks|key|3019307|text|$today+=+date('Y-m-d');//Y-m-d+H:i:s
$expireDate+=+new+DateTime($row->expireDate);//+From+db+
$date1=date_create($today);
$date2=date_create($expireDate->format('Y-m-d'));
$diff=date_diff($date1,$date2);

//echo+$timeDiff;
if($diff->days+>=+30){
++++echo+"Expired.";
}else{
++++echo+"Not+expired.";
}|type|code-block|depth|inlineStyleRanges|entityRanges|data|syntax|javascript|3019308|unstyled|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|G|8|@]|9|@]|A|$B|C]]|$1|D|3|-4|5|E|7|H|8|@]|9|@]|A|$]]]|F|$]]

<pre><code>$today = date('Y-m-d');//Y-m-d H:i:s
$expireDate = new DateTime($row-&gt;expireDate);// From db 
$date1=date_create($today);
$date2=date_create($expireDate-&gt;format('Y-m-d'));
$diff=date_diff($date1,$date2);

//echo $timeDiff;
if($diff-&gt;days &gt;= 30){
 echo "Expired.";
}else{
 echo "Not expired.";
}
</code></pre>

blocks|key|3019275|text|您可以将日期转换为UNIX时间戳，并以秒为单位比较它们之间的差异。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3019276|$today_date=date("Y-m-d");
$entered_date=$_POST['date'];
$dateTimestamp1+=+strtotime($today_date);
$dateTimestamp2+=+strtotime($entered_date);
$diff=+$dateTimestamp1-$dateTimestamp2;
//echo+$diff;
if+($diff<=0)
+++{
+++++echo+"Enter+a+valid+date";
+++}|code-block|syntax|javascript|3019277|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

You can convert the dates into UNIX timestamps and compare the difference between them in seconds.

<pre><code>$today_date=date("Y-m-d");
$entered_date=$_POST['date'];
$dateTimestamp1 = strtotime($today_date);
$dateTimestamp2 = strtotime($entered_date);
$diff= $dateTimestamp1-$dateTimestamp2;
//echo $diff;
if ($diff&lt;=0)
 {
 echo "Enter a valid date";
 }
</code></pre>

blocks|key|3233617|text|这里有一个关于如何在分钟内获得两个日期之间的差的方法。|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|3233618|//+set+dates
$date_compare1=+date("d-m-Y+h:i:s+a",+strtotime($date1));
//+date+now
$date_compare2=+date("d-m-Y+h:i:s+a",+strtotime($date2));

//+calculate+the+difference
$difference+=+strtotime($date_compare1)+-+strtotime($date_compare2);
$difference_in_minutes+=+$difference+/+60;

echo+$difference_in_minutes;|code-block|syntax|javascript|3233619|entityMap^0|M|5|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|P|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|D|@]|E|$]]]|L|$]]

Here's a way on how to get the difference between two dates in minutes.

<pre><code>// set dates
$date_compare1= date("d-m-Y h:i:s a", strtotime($date1));
// date now
$date_compare2= date("d-m-Y h:i:s a", strtotime($date2));

// calculate the difference
$difference = strtotime($date_compare1) - strtotime($date_compare2);
$difference_in_minutes = $difference / 60;

echo $difference_in_minutes;
</code></pre>

blocks|key|3233573|text|我也遇到过这个问题，我通过以下方式解决了它：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3233574|$today+=+date("Ymd");
$expire+=+str_replace('-',+'',+$row->expireDate);+//from+db

if(($today+-+$expire)+>+$NUMBER_OF_DAYS)+
{+
++++//do+something;+
}|code-block|syntax|javascript|3233575|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

I had that problem too and I solve it by:

<pre><code>$today = date("Ymd");
$expire = str_replace('-', '', $row-&gt;expireDate); //from db

if(($today - $expire) &gt; $NUMBER_OF_DAYS) 
{ 
 //do something; 
}
</code></pre>

blocks|key|3019382|text|下面是我关于如何在PHP中获得两个日期之间的天数差的方法。注意'!‘的用法在格式中丢弃日期的时间部分，这要归功于DateTime+createFromFormat+without+time的信息。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|3019383|$today+=+DateTime::createFromFormat('!Y-m-d',+date('Y-m-d'));
$wanted+=+DateTime::createFromFormat('!d-m-Y',+$row["WANTED_DELIVERY_DATE"]);
$diff+=+$today->diff($wanted);
$days+=+$diff->days;
if+(($diff->invert)+!=+0)+$days+=+-1+*+$days;
$overdue+=+(($days+<+0)+?+true+:+false);
print+"\n";|code-block|syntax|javascript|3019384|entityMap|0|LINK|mutability|MUTABLE|url|http://www.freeklijten.nl/2015/08/12/DateTime-createFromFormat-without-time^0|1K|12|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@$A|R|B|S|1|T]]|C|$]]|$1|D|3|E|5|F|7|U|8|@]|9|@]|C|$G|H]]|$1|I|3|-4|5|6|7|V|8|@]|9|@]|C|$]]]|J|$K|$5|L|M|N|C|$O|P]]]]

Here's my spin on how to get the difference in days between two dates with PHP.
Note the use of '!' in the format to discard the time part of the dates, thanks to info from <a href="http://www.freeklijten.nl/2015/08/12/DateTime-createFromFormat-without-time" rel="nofollow noreferrer">DateTime createFromFormat without time</a>.

<pre><code>$today = DateTime::createFromFormat('!Y-m-d', date('Y-m-d'));
$wanted = DateTime::createFromFormat('!d-m-Y', $row["WANTED_DELIVERY_DATE"]);
$diff = $today-&gt;diff($wanted);
$days = $diff-&gt;days;
if (($diff-&gt;invert) != 0) $days = -1 * $days;
$overdue = (($days &lt; 0) ? true : false);
print "&lt;!-- (".(($days &gt; 0) ? '+' : '').($days).") --&gt;\n";
</code></pre>

blocks|key|3019406|text|如果您希望在执行密码重置时某个日期($date)在某个时间间隔(例如令牌到期日期)过期，则可以执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3019407|$date+=+$row->expireDate;

$date->add(new+DateInterval('PT24H'));+//+adds+24+hours

$now+=+new+\DateTime();

if($now+<+$date)+{+/*+expired+after+24+hours+*/+}|code-block|syntax|javascript|3019408|但在您的情况下，您可以像下面这样进行比较：|3019409|$today+=+new+DateTime('Y-m-d');

$date+=+$row->expireDate;

if($today+<+$date)+{+/*+do+something+*/+}|3019410|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

If you want a date ($date) to get expired in some interval for example a token expiration date when performing a password reset, here's how you can do:

<pre><code>$date = $row-&gt;expireDate;

$date-&gt;add(new DateInterval('PT24H')); // adds 24 hours

$now = new \DateTime();

if($now &lt; $date) { /* expired after 24 hours */ }
</code></pre>

But in your case you could do the comparison just as the following:

<pre><code>$today = new DateTime('Y-m-d');

$date = $row-&gt;expireDate;

if($today &lt; $date) { /* do something */ }
</code></pre>

blocks|key|3019302|text|我在博客上找到了答案，答案很简单：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3019303|strtotime(date("Y"."-01-01"))+-strtotime($newdate))/86400|code-block|syntax|javascript|3019304|你会得到两个日期之间的天数。|3019305|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

Found the answer on a blog and it's as simple as:

<pre><code>strtotime(date("Y"."-01-01")) -strtotime($newdate))/86400
</code></pre>

And you'll get the days between the 2 dates.

blocks|key|295505|text|这是因为PHP的字符串比较逻辑。你可以简单的检查..。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|295506|if+($startdate+<+$date)+{//+do+something}+
if+($startdate+>+$date)+{//+do+something}|code-block|syntax|javascript|295507|两个日期的格式必须相同。数字需要向左填零，并从最高有效位到最低有效位排序。Y-m-d和Y-m-d+H:i:s满足这些条件。|offset|length|style|CODE|295508|entityMap^0|0|0|11|5|17|B|0^^$0|@$1|2|3|4|5|6|7|O|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Q|8|@$I|R|J|S|K|L]|$I|T|J|U|K|L]]|9|@]|A|$]]|$1|M|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|N|$]]

This works because of PHP's string comparison logic. Simply you can check...

<pre><code>if ($startdate &lt; $date) {// do something} 
if ($startdate &gt; $date) {// do something}
</code></pre>

Both dates must be in the same format. Digits need to be zero-padded to the left and ordered from most significant to least significant. <code>Y-m-d</code> and <code>Y-m-d H:i:s</code> satisfy these conditions.

blocks|key|295526|text|首先，尝试为服务器的当前日期时间指定所需的格式：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|295527|295528|获取当前日期时间|ordered-list-item|295529|295530|$current_date+=+getdate();|295531|Separate如您所愿管理它们的日期和时间：|unordered-list-item|295532|295533|$current_dateyear.'-'.$current_datemon.'-'.$current_datemday；=+$current_date'hours'.':'.$current_date'minutes'.':'.$current_date'seconds'；=+$current_date_only+=+$current_time_only|295534|295535|根据您在数据库中使用的是donly+date还是datetime进行比较：|295536|295537|$today+=$current_date_only。‘'.$current_time_only；|295538|或|295539|$today+=+$current_date_only；|295540|if($today+<+$expireDate)|295541|希望能有所帮助|295542|entityMap^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|14|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|15|8|@]|9|@]|A|$]]|$1|C|3|D|5|E|7|16|8|@]|9|@]|A|$]]|$1|F|3|-4|5|6|7|17|8|@]|9|@]|A|$]]|$1|G|3|H|5|6|7|18|8|@]|9|@]|A|$]]|$1|I|3|J|5|K|7|19|8|@]|9|@]|A|$]]|$1|L|3|-4|5|6|7|1A|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|1B|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|P|3|Q|5|E|7|1D|8|@]|9|@]|A|$]]|$1|R|3|-4|5|6|7|1E|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1F|8|@]|9|@]|A|$]]|$1|U|3|V|5|6|7|1G|8|@]|9|@]|A|$]]|$1|W|3|X|5|6|7|1H|8|@]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1I|8|@]|9|@]|A|$]]|$1|10|3|11|5|6|7|1J|8|@]|9|@]|A|$]]|$1|12|3|-4|5|6|7|1K|8|@]|9|@]|A|$]]]|13|$]]

first of all, try to give the format you want to the current date time of your server:

<ol>
<li>Obtain current date time

$current_date = getdate();</li>
<li>Separate date and time to manage them as you wish:</li>
</ol>

$current_date_only = $current_date[year].'-'.$current_date[mon].'-'.$current_date[mday];
$current_time_only = $current_date['hours'].':'.$current_date['minutes'].':'.$current_date['seconds'];

<ol start="3">
<li>Compare it depending if you are using donly date or datetime in your DB:

$today = $current_date_only.' '.$current_time_only;

or

$today = $current_date_only;

if($today &lt; $expireDate)</li>
</ol>

hope it helps

How can I compare two dates in PHP?

The date is stored in the database in the following format 

<blockquote>
 2011-10-2
</blockquote>

If I wanted to compare today's date against the date in the database to see which one is greater, how would I do it?

I tried this,

<pre><code>$today = date("Y-m-d");
$expire = $row-&gt;expireDate //from db

if($today &lt; $expireDate) { //do something; }
</code></pre>

but it doesn't really work that way. What's another way of doing it?

How can I compare two dates in PHP?

如何在PHP中比较两个日期？日期以以下格式存储在数据库中 2011-10-2如果我想将今天的日期与数据库中的日期进行比较，看看哪一个更大，我该怎么做呢？我试过了，$today = date("Y-m-d");$expire = $row->expireDate //from dbif($today < $expireDate) { //do something; }但它并不是真的那样工作。另一种方

问如何在PHP中比较两个日期？
EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在PHP中比较两个日期？EN

回答 13

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在PHP中比较两个日期？
EN