MongoDB $second

In MongoDB, the $second aggregation pipeline operator returns the second portion of a date as a number between 0 and 59. The value can also be 60 to account for leap seconds whenever applicable.

You can optionally specify a timezone to use for the result.

The $second operator accepts either a date (as either a Date, a Timestamp, or an ObjectId), or a document that specifies the date and timezone to use.

Continue reading

MongoDB $week

In MongoDB, the $week aggregation pipeline operator returns the week of the year for a date as a number between 0 and 53.

When using the $week operator, you can optionally specify a timezone to use for the result.

The $week operator accepts either a date (as either a Date, a Timestamp, or an ObjectId), or a document that specifies the date and timezone to use.

Continue reading

MongoDB $isoWeekYear

In MongoDB, the $isoWeekYear aggregation pipeline operator returns the ISO week-numbering year for a given date value. This is the year number in ISO 8601 format.

When using the $isoWeekYear operator, you can optionally specify a timezone to use for the result.

The $isoWeekYear operator accepts either a date (as either a Date, a Timestamp, or an ObjectId), or a document that specifies the date and timezone to use.

Continue reading

MongoDB $isoWeek

In MongoDB, the $isoWeek aggregation pipeline operator returns the week number in ISO 8601 format, ranging from 1 to 53.

When using the $isoWeek operator, you can optionally specify a timezone to use for the result.

The $isoWeek operator accepts either a date (as either a Date, a Timestamp, or an ObjectId), or a document that specifies the date and timezone to use.

Continue reading

MongoDB $isoDayOfWeek

In MongoDB, the $isoDayOfWeek aggregation pipeline operator returns the weekday number in ISO 8601 format, ranging from 1 (for Monday) to 7 (for Sunday).

You can optionally specify a timezone to use for the result.

The $isoDayOfWeek operator accepts either a date (as either a Date, a Timestamp, or an ObjectId), or a document that specifies the date and timezone to use.

Continue reading