MongoDB Query Language (MQL) Date Expression Operators
Date expression operators perform operations on date and time values.
$dateAdd
The $dateAdd operator adds a specified number of time units (day, hour, month etc) to a date.
$dateDiff
The $dateDiff operator calculates the difference between two dates in various units such as years, months, days, etc.
$dateFromParts
The $dateFromParts operator constructs a date from individual components.
$dateFromString
The $dateDiff operator converts a date/time string to a date object.
$dateSubtract
The $dateSubtract operator subtracts a specified amount of time from a date.
$dateToParts
The $dateToParts operator decomposes a date into its individual parts such as year, month, day, and more.
$dateToString
The $dateToString operator converts a date object into a formatted string.
$dateTrunc
The $dateTrunc operator truncates a date to a specified unit.
$dayOfMonth
The $dayOfMonth operator extracts the day of the month from a date.
$dayOfWeek
The $dayOfWeek operator extracts the day of the week from a date.
$dayOfYear
The $dayOfYear operator extracts the day of the year from a date.
$hour
The $hour operator returns the hour portion of a date as a number between 0 and 23.
$isoDayOfWeek
The $isoDayOfWeek operator returns the weekday number in ISO 8601 format, ranging from 1 (Monday) to 7 (Sunday).
$isoWeek
The $isoWeek operator returns the week number of the year in ISO 8601 format, ranging from 1 to 53.
$isoWeekYear
The $isoWeekYear operator returns the year number in ISO 8601 format, which can differ from the calendar year for dates at the beginning or end of the year.
$millisecond
The $millisecond operator extracts the milliseconds portion from a date value.
$minute
The $minute operator extracts the minute portion from a date value.
$month
The $month operator extracts the month portion from a date value.
$second
The $second operator extracts the seconds portion from a date value.
$week
The $week operator returns the week number for a date as a value between 0 and 53.
$year
The $year operator returns the year for a date as a four-digit number.