DAY (NoSQL query)

Returns the value of the day for the provided date and time.

Syntax

DAY(<date_time>)  

Arguments

Return types

Returns a numeric value that is a positive integer.

Examples

The following example shows the results of using this function on different date values.

SELECT VALUE {
    "case1": DAY("2024-01-10"),
    "case2": DAY("2000-12-12T10:00:00"),
    "case3": DAY("1989-03-03T12:12:12.1234567Z")
}

[
    {
        "case1": 10,
        "case2": 12,
        "case3": 3
    }
]

Remarks

• This function behaves the same as the DateTimePart function when the day is specified.
• This function benefits from the use of a range index.

Related content

• YEAR
• MONTH
• DATETIMEPART