Date expression - operators

Date expression operators perform operations on date and time values.

	Description
$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.