$dateTrunc (aggregation)

binSize and 和unit Fields字段

Together, binSize and unit specify the time period used in the $dateTrunc calculation.binSize和unit一起指定$dateTrunc计算中使用的时间段。

For example:例如：

• If binSize is 1 and unit is hours, the time period is one hour. 如果binSize为1，unit为hours，则时间段为一小时。For the date 2021-03-20T11:30:05Z, $dateTrunc returns 2021-03-20T11:00:00Z.对于日期2021-03-20T11:30:05Z，$dateTrunc返回2021-03-20T11:00:00Z。
• If binSize is 2 and unit is hours, the time period is two hours. 如果binSize为2，unit为hours，则时间段为两小时。For the date 2021-03-20T11:30:05Z, $dateTrunc returns 2021-03-20T10:00:00Z.对于date 2021-03-20T11:30:05Z，$dateTrunc返回2021-03-20T10:00:00Z。

$dateTrunc:

• Divides the time for the $dateTrunc calculation into binSize time periods in the specified time unit.将$dateTrunc计算的时间按照指定的时间unit划分为binSize时间段。

  The time periods start at a reference date, which is determind by unit. 时间段从参考日期开始，参考日期由unit决定。If unit is:如果unit为：

  • A string other than week, $dateTrunc uses a reference date of 2000-01-01T00:00:00.00Z. 除了week，$dateTrunc之外的字符串使用的参考日期为2000-01-01T00:00:00.00Z。For example, if binSize is 10 and unit is year, example time periods are:例如，如果binSize为10，unit为year，则时间段示例为：

    • 2000-01-01T00:00:00.00Z
    • 2010-01-01T00:00:00.00Z
    • 2020-01-01T00:00:00.00Z
  • Equal to week, $dateTrunc uses a reference date that is set to the earliest first day of the week that is greater than or equal to 2000-01-01. 等于week，$dateTrunc使用的参考日期设置为一周中最早的第一天，大于或等于2000-01-01。The first day is set using startOfWeek (the default is Sunday).使用startOfWeek设置第一天（默认值为星期日）。
• Returns the lower boundary of the time period that the date is in. 返回date所在时间段的下限。The boundary is returned as an ISODate. 边界将以ISODate的形式返回。If the binSize field is 1, $dateTrunc sets the least significant parts (as determined by unit) of the returned ISODate to 0 and keeps the rest of the ISODate the same.如果binSize字段为1，$dateTrunc将返回的ISODate设置为0的最低有效部分（由unit确定），并保持ISODate的其余部分不变。

If unit is:如果unit为：

• year: $dateTrunc returns the ISODate for the start of January 1 for the year in date.：$dateTrunc返回date中年份1月1日开始的ISODate。

• quarter: $dateTrunc returns the ISODate for the start of the first day of the calendar quarter in date.：$dateTrunc返回日历季度date第一天开始的ISODate。

  The quarters are:季度为：

  • January to March1月至3月
  • April to June4月至6月
  • July to September7月至9月
  • October to December10月至12月
• month: $dateTrunc returns the ISODate for the start of the first day of the month in date.：$dateTrunc返回date中月份第一天开始的ISODate。
• week: $dateTrunc returns the ISODate for the start of the startOfWeek day in date. ：$dateTrunc返回date中startOfWeek日开始的ISODate。The default for startOfWeek is Sunday.startOfWeek的默认值是星期天。
• day: $dateTrunc returns the ISODate for the start of the day in date.：$dateTrunc返回date中一天开始的ISODate。
• hour: $dateTrunc returns the ISODate for the start of the hour in date.：$dateTrunc返回date中一小时开始的ISODate。
• minute: $dateTrunc returns the ISODate for the start of the minute in date.：$dateTrunc返回date中一分钟开始的ISODate。
• second: $dateTrunc returns the the ISODate for start of the second in date.：$dateTrunc返回date中一秒钟开始的ISODate。

unit and 和startOfWeek Fields字段

If unit is:如果unit为：

• A string other than week, startOfWeek is ignored.除week以外的字符串，则忽略startOfWeek。

• Equal to week and startOfWeek is:等于week并且startOfWeek是：

  • Specified: $dateTrunc uses startOfWeek as the first day of the week for the calculation.指定：$dateTrunc使用startOfWeek作为计算周的第一天。
  • Omitted: $dateTrunc uses Sunday as the start of the week for the calculation.省略：$dateTrunc使用星期天作为计算周的开始。

Truncate Order Dates in a $project Pipeline Stage截断$project管道阶段中的订单日期

This example uses $dateTrunc in a $project stage to truncate the cake sales orderDate values to two weeks:本例在$project阶段使用$dateTrunc将蛋糕销售orderDate值截断为两周：

db.cakeSales.aggregate( [
   {
      $project: {
         _id: 1,
         orderDate: 1,
         truncatedOrderDate: {
            $dateTrunc: {
               date: "$orderDate", unit: "week", binSize: 2,
               timezone: "America/Los_Angeles", startOfWeek: "Monday"
            }
         }
      }
   }
] )

In the example:在示例中：

• $project includes the _id, orderDate, and truncatedOrderDate fields in the output.$project在输出中包括_id、orderDate和truncatedOrderDate字段。
• $dateTrunc truncates the orderDate field to a 2binSize week unit time period in the America/Los_Angelestimezone with startOfWeek set to Monday.$dateTrunc将orderDate字段截断为America/Los_Angeles时区中的2 binSize周单位时间段，startOfWeek设置为星期一。

In this example output, the truncated orderDate is shown in the truncatedOrderDate field:在此示例输出中，截断的orderDate显示在truncatedOrderDate字段中：

[
   {
      _id: 0,
      orderDate: ISODate("2020-05-18T14:10:30.000Z"),
      truncatedOrderDate: ISODate("2020-05-11T07:00:00.000Z")
   },
   {
      _id: 1,
      orderDate: ISODate("2021-03-20T11:30:05.000Z"),
      truncatedOrderDate: ISODate("2021-03-15T07:00:00.000Z")
   },
   {
      _id: 2,
      orderDate: ISODate("2021-01-11T06:31:15.000Z"),
      truncatedOrderDate: ISODate("2021-01-04T08:00:00.000Z")
   },
   {
      _id: 3,
      orderDate: ISODate("2020-02-08T13:13:23.000Z"),
      truncatedOrderDate: ISODate("2020-02-03T08:00:00.000Z")
   },
   {
      _id: 4,
      orderDate: ISODate("2019-05-18T16:09:01.000Z"),
      truncatedOrderDate: ISODate("2019-05-13T07:00:00.000Z")
   },
   {
      _id: 5,
      orderDate: ISODate("2019-01-08T06:12:03.000Z"),
      truncatedOrderDate: ISODate("2019-01-07T08:00:00.000Z")
   }
]

Truncate Order Dates and Obtain Quantity Sum in a $group Pipeline Stage截断订单日期并在$group管道阶段获取数量总和

This example uses $dateTrunc in a $group stage to truncate the cake sales orderDate values to six months and return the sum of the quantity values:本例在$group阶段使用$dateTrunc将蛋糕销售订单日期值截断为六个月，并返回数量值之和：

db.cakeSales.aggregate( [
   {
      $group: {
         _id: {
            truncatedOrderDate: {
               $dateTrunc: {
                  date: "$orderDate", unit: "month", binSize: 6
               }
            }
         },
         sumQuantity: { $sum: "$quantity" }
      }
   }
] )

In the example:在示例中：

• $group has the _id field set to the truncatedOrderDate field to group the cakeSales documents, and returns the sum of the quantity values for each group using $sum.$group将_id字段设置为truncatedOrderDate字段，以对cakeSales文档进行分组，并使用$sum返回每个组的quantity值之和。
• $dateTrunc truncates the orderDate field to a 6binSize month unit time period.$dateTrunc将orderDate字段截断为6个月的单位时间段。

In this example output, the truncated orderDate is shown in the truncatedOrderDate field and the quantity sum is shown in the sumQuantity field:在此示例输出中，截断的orderDate显示在truncatedOrderDate字段中，quantity总和显示在sumQuantity字段中：

[
   {
      _id: { truncatedOrderDate: ISODate("2020-01-01T00:00:00.000Z") },
      sumQuantity: 224
   },
   {
      _id: { truncatedOrderDate: ISODate("2021-01-01T00:00:00.000Z") },
      sumQuantity: 285
   },
   {
      _id: { truncatedOrderDate: ISODate("2019-01-01T00:00:00.000Z") },
      sumQuantity: 296
   }
]