blocks|key|4254423|text|你可以尝试一些解决方案。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4254424|我不知道您的查询是如何设置的，但是您可以在上面添加一个select，并说明查询中的差异，然后只返回其中的日期部分。|4254425|...->select(DB::raw('DISTINCT+DATE(DATE_ADD(your_date_column,+INTERVAL+x+HOUR))+AS+your_date_column'))|code-block|syntax|javascript|4254426|其中，your_date_column是您要查找的日期列的名称，x是要更改的小时数，如果您落后了，它可能是一个负值。这将返回出现在数据库中的唯一日期的集合，这些日期由小时数偏移。|offset|length|style|CODE|4254427|另一种解决方案是循环遍历结果集，并将它们设置为日期。碳会让这一切变得相当容易。|4254428|foreach($results+as+$result)+{
++++$date+=+\Carbon::createFromTimeStamp($result->your_date_column);
++++$date->addHours($hoursToAdd);
++++$result->your_date_column+=+$date->toDateString();
}|4254429|entityMap^0|0|0|0|3|G|W|1|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$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|@]|9|@]|A|$]]|$1|Q|3|R|5|F|7|13|8|@]|9|@]|A|$G|H]]|$1|S|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|T|$]]

There would be a few solutions you could try.

I don't know how you have your query setup but you could possibly add a select on there and account for the difference right in your query and return just the date portion of it.

<pre><code>...-&gt;select(DB::raw('DISTINCT DATE(DATE_ADD(your_date_column, INTERVAL x HOUR)) AS your_date_column'))
</code></pre>

Where <code>your_date_column</code> is the name of the column of the dates you are looking for and <code>x</code> is the number of hours to change, which can be a negative value if you are behind. This will return a collection of unique dates which appear in your database which are offset by the number of hours. 

The other solution would be to loop through your result set and set them to the dates as you go. Carbon would make this fairly easy.

<pre><code>foreach($results as $result) {
 $date = \Carbon::createFromTimeStamp($result-&gt;your_date_column);
 $date-&gt;addHours($hoursToAdd);
 $result-&gt;your_date_column = $date-&gt;toDateString();
}
</code></pre>

blocks|key|4116379|text|这种类型的选择允许您只选择字段的固定部分，然后您可以按所选部分进行分组。因此，如果您只需要日期字段中的前10个字符，您可以像这样选择它。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4116380|SELECT+SUBSTRING('date',1,10)+AS+trimmed_date+
FROM+table
GROUP+BY+trimmed_date;|code-block|syntax|javascript|4116381|这将以trimmed_date的形式返回信息。如果你仍然希望它是日期，你可以这样做。|4116382|SELECT+SUBSTRING('date',1,10)
FROM+table
GROUP+BY+SUBSTRING('date',1,10);|4116383|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|$]]

This type of select allows you select just a fixed portion of a field, than you can group by the portion you selected. So if you just need the first 10 characters from the date field you could select it like this. 

<pre><code>SELECT SUBSTRING('date',1,10) AS trimmed_date 
FROM table
GROUP BY trimmed_date;
</code></pre>

This will return the information as trimmed_date. If you still wanted it to be date you could do it this way.

<pre><code>SELECT SUBSTRING('date',1,10)
FROM table
GROUP BY SUBSTRING('date',1,10);
</code></pre>

blocks|key|4254464|text|从数据库中提取日期/时间数据作为unix时间戳，应该类似于13249141986。创建dataTable时，请使用该列的渲染器。这里有一个提示：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4254465|var+table+=+$('#example').DataTable(+{
++++"data":+dataSet,+//+in+my+case+I'm+building+using+data+from+a+variable
++++"columns":+[
++++++++{+"title":+"Name"+},
++++++++{+"title":+"Modified",
++++++++++"render":+function+(data,+type,+full,+meta)+{
++++++++++++++return+type+===+'display'+?+jQuery.datepicker.formatDate('M+dd,+yy',+new+Date(1000+*+data))+:+data;
++++++++++++}
+++++++++}
++++]
}+);++|code-block|syntax|javascript|4254466|当调用渲染器进行显示时，我将其解析为可读内容，否则将返回原始秒数。这应该可以让你开始学习了。|4254467|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|$]]

Pull your date/time data from the database as a unix timestamp, should look something like 13249141986. When you create your dataTable, use a renderer for that column. Here is a hint:

<pre><code>var table = $('#example').DataTable( {
 "data": dataSet, // in my case I'm building using data from a variable
 "columns": [
 { "title": "Name" },
 { "title": "Modified",
 "render": function (data, type, full, meta) {
 return type === 'display' ? jQuery.datepicker.formatDate('M dd, yy', new Date(1000 * data)) : data;
 }
 }
 ]
} ); 
</code></pre>

When the renderer is called for displaying, I'm parsing it to something readable, otherwise I'm just returning the raw seconds. This should get you started.

I'm using DataTables.net for rendering data in my laravel project. Now I came across with issue. 
In few columns I have data in dd.mm.yyyy H:i . I'm also using <a href="https://datatables.net/examples/api/multi_filter_select.html" rel="nofollow">DataTables.net select inputs filter</a>

My column sorting does as it should (clicking on table headers). The problem is that select inputs are filled with ex: 

<pre><code>31.12.2014 08:12 
</code></pre>

Now what I want is that filter will sort those columns as date (not date time). Because if my table has 100 rows, that means 100 select options under fields with datetime values. I want them to be grouped by date ignoring time. 

Any solutions?

DataTables.net select inputs filter ignore time in datetime

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

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

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

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

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

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

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

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

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

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

我正在使用DataTables.net在我的laravel项目中呈现数据。现在我遇到了问题。在几个列中，我有dd.mm.yyyy H:i中的数据。我也在使用我的列排序就像它应该做的那样(单击表标题)。问题是select输入中填充了ex：31.12.2014 08:12 现在我想要的是过滤器将这些列排序为日期(而不是日期...

问DataTables.net选择输入筛选器忽略日期时间中的时间
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问DataTables.net选择输入筛选器忽略日期时间中的时间EN