mongoDB:$dateToString 格式以 15 分钟为间隔显示时间 [英] mongoDB: $dateToString format to show time by 15min interval
问题描述
我这里有一个例子,https://mongoplayground.net/p/fqxBy6NAZXL
如您所见,最终结果具有dateHour"和minuteBucket"字段.我将时间除以 15.0 分钟,因此minuteBucket"值将始终为 0、1、2、3 之一
As you will see final result has "dateHour" and "minuteBucket" fields. I am dividing time by 15.0 minutes so "minuteBucket" value will always be one of 0, 1, 2, 3
dateHour"现在不显示分钟.
"dateHour" is not showing minutes right now.
预期:
我需要删除minuteBucket"字段,但仍将时间除以 15 分钟以进行此聚合,并显示带有 HH:MM 的dateHour",它始终按 15 分钟四舍五入.例如,它应该根据其时间以这种格式显示.
I need to remove "minuteBucket" field but still divide time by 15 minutes for this aggregation and show "dateHour" with HH:MM where it always round up by 15 minutes. example it should look like in this format based on its time.
"2020-03-19T18:00:00", "2020-03-19T18:15:00","2020-03-19T18:30:00","2020-03-19T18:45:00"
推荐答案
您可以使用 $dateFromString 解析 dateHour
然后添加 _id.minutebucket
乘以 900000
(15 分钟 * 60 秒 * 1000毫秒):
You can use $dateFromString to parse dateHour
and then add _id.minutebucket
multiplied by 900000
(15 minutes * 60 seconds * 1000 miliseconds):
{
dateHour: {
$let: {
vars: { parsedDate: { $dateFromString: { dateString: "$_id.dateHour", format: "%Y-%m-%dT%H" } } },
in: { $toString: [ { $add: [ "$$parsedDate", { $multiply: [ "$_id.minuteBucket", 900000 ] } ] } ] }
}
}
}
这篇关于mongoDB:$dateToString 格式以 15 分钟为间隔显示时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!