blocks|key|5019525|text|您可以使用以下示例：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5019526|$datetime1+=+new+DateTime('2009-10-11');
$datetime2+=+new+DateTime('2009-10-13');
$interval+=+$datetime1->diff($datetime2);
echo+$interval->format('%25R%25a+days');|code-block|syntax|javascript|5019527|在Laravel中，不要忘记添加以下内容：|5019528|use+DateTime;|5019529|另一个选择是您可以使用SQL，查看我的示例：|5019530|++++++return+DB::table('corporation')->join('corporation_subscription','corporation.id','=','corporation_subscription.corp_id')
++++++++->where('corporation.id','=',$id)
++++++++->where('corporation_subscription.period','>=',DB::raw('DATEDIFF(NOW(),corporation_subscription.created_at)'))
++++++++->where('corporation_subscription.status','!=',+'cancel'+)
++++++++->get();|5019531|这对你也有帮助：DB::raw('DATEDIFF(NOW(),corporation_subscription.created_at)'))|offset|length|style|CODE|5019532|entityMap^0|0|0|0|0|0|0|8|1R|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|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|N|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|O|3|P|5|6|7|12|8|@$Q|13|R|14|S|T]]|9|@]|A|$]]|$1|U|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|V|$]]

You can use this sample:

<pre><code>$datetime1 = new DateTime('2009-10-11');
$datetime2 = new DateTime('2009-10-13');
$interval = $datetime1-&gt;diff($datetime2);
echo $interval-&gt;format('%R%a days');
</code></pre>

in Laravel just donot forget to add this:

<pre><code>use DateTime;
</code></pre>

the other option is you can use SQL, look at my sample:

<pre><code> return DB::table('corporation')-&gt;join('corporation_subscription','corporation.id','=','corporation_subscription.corp_id')
 -&gt;where('corporation.id','=',$id)
 -&gt;where('corporation_subscription.period','&gt;=',DB::raw('DATEDIFF(NOW(),corporation_subscription.created_at)'))
 -&gt;where('corporation_subscription.status','!=', 'cancel' )
 -&gt;get();
</code></pre>

this will help you too : <code>DB::raw('DATEDIFF(NOW(),corporation_subscription.created_at)'))</code>

blocks|key|5019553|text|在Laravel中，您可以使用碳来比较日期/时间。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|5019554|示例|offset|length|style|BOLD|5019555|$start+=+new+Carbon\Carbon('2014-01-05+12:00:00');
$end+=+new+Carbon\Carbon('2014-01-01+12:00:00');
echo+$end->diffInDays($start);|code-block|syntax|javascript|5019556|也可以直接比较db中的数据。|5019557|$customer+=App\Customer::first();
$start+=+$customer->db_date_column;
$end+=+new+Carbon\Carbon('2014-01-01+12:00:00');
echo+$end->diffInDays($start);|5019558|更多信息http://carbon.nesbot.com/docs/#api-difference|5019559|更新如果您想以小时表示时间差，则可以使用此$end-diffInHours($start);。|CODE|5019560|entityMap|0|LINK|mutability|MUTABLE|url|http://carbon.nesbot.com/docs/#api-difference^0|0|0|2|0|0|0|0|4|19|0|0|0|2|L|P|0^^$0|@$1|2|3|4|5|6|7|13|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|14|8|@$D|15|E|16|F|G]]|9|@]|A|$]]|$1|H|3|I|5|J|7|17|8|@]|9|@]|A|$K|L]]|$1|M|3|N|5|6|7|18|8|@]|9|@]|A|$]]|$1|O|3|P|5|J|7|19|8|@]|9|@]|A|$K|L]]|$1|Q|3|R|5|6|7|1A|8|@]|9|@$D|1B|E|1C|1|1D]]|A|$]]|$1|S|3|T|5|6|7|1E|8|@$D|1F|E|1G|F|G]|$D|1H|E|1I|F|U]]|9|@]|A|$]]|$1|V|3|-4|5|6|7|1J|8|@]|9|@]|A|$]]]|W|$X|$5|Y|Z|10|A|$11|12]]]]

In Laravel you can use Carbon for comparing date/time

Example

<pre><code>$start = new Carbon\Carbon('2014-01-05 12:00:00');
$end = new Carbon\Carbon('2014-01-01 12:00:00');
echo $end-&gt;diffInDays($start);
</code></pre>

Or you can directly compare date from db

<pre><code>$customer =App\Customer::first();
$start = $customer-&gt;db_date_column;
$end = new Carbon\Carbon('2014-01-01 12:00:00');
echo $end-&gt;diffInDays($start);
</code></pre>

More information <a href="http://carbon.nesbot.com/docs/#api-difference" rel="nofollow">http://carbon.nesbot.com/docs/#api-difference</a>

Update 
 if you want the time diff in hour, you can use this <code>$end-diffInHours($start);</code> instead.

blocks|key|2690911|text|实际上，您可以在DB查询中完成所有这些操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2690912|$date+=+'2015-03-11+06:29:56';
$alreadyBooked+=+DB::table('bookings')
+++++++++++++++++++->whereRaw('ABS(TIMESTAMPDIFF(MINUTE,+datetime,+?))+<=+120',+[$date])
+++++++++++++++++++->exists();

if($alreadyBooked){
++++//+show+error
}|code-block|syntax|javascript|2690913|解释|2690914|?是$date的占位符。这些被称为绑定，主要用于获取干净的查询和防止SQL注入。|offset|length|style|CODE|2690915|TIMESTAMPDIFF(MINUTE,+...将在分钟内返回输入日期、时间和存储在数据库字段中的时间的差异。如果该值较小或等于120+(2小时=+120分钟)，则与条件匹配。|2690916|ABS将使值“无符号”。-60变成60|2690917|entityMap^0|0|0|0|0|1|2|5|0|0|P|0|0|3|C|3|H|2|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|X|8|@$K|Y|L|Z|M|N]|$K|10|L|11|M|N]]|9|@]|A|$]]|$1|O|3|P|5|6|7|12|8|@$K|13|L|14|M|N]]|9|@]|A|$]]|$1|Q|3|R|5|6|7|15|8|@$K|16|L|17|M|N]|$K|18|L|19|M|N]|$K|1A|L|1B|M|N]]|9|@]|A|$]]|$1|S|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]]|T|$]]

Actually you can do all of this in a DB query:

<pre><code>$date = '2015-03-11 06:29:56';
$alreadyBooked = DB::table('bookings')
 -&gt;whereRaw('ABS(TIMESTAMPDIFF(MINUTE, datetime, ?)) &lt;= 120', [$date])
 -&gt;exists();

if($alreadyBooked){
 // show error
}
</code></pre>

<h3>Explanation</h3>

<code>?</code> is a placeholder for the <code>$date</code>. Those are called bindings and are mostly used to get a clean query and prevent SQL injection.

<code>TIMESTAMPDIFF(MINUTE, ...</code> will return the difference of the input date time and the one stored in the database field in minutes. If that value is smaller or equal to 120 (2 hours = 120 minutes) it matches the condition.

<code>ABS</code> will make the value "unsigned". <code>-60</code> becomes <code>60</code>

I'm getting date and time from my customer side using laravel. How can we compare given date and time with database and return result to customer?

For Example, if I am getting Date and time from customer and I want to show him rows which do not clash with his date and time.

How to compare date and time differently in laravel

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我从客户那得到的日期和时间用的是拉拉。如何将给定的日期和时间与数据库进行比较，并将结果返回给客户？例如，如果我从客户那里得到日期和时间，并且我想向他显示与他的日期和时间不冲突的行。

问如何在拉拉中比较不同的日期和时间
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何在拉拉中比较不同的日期和时间EN