AGO (NoSQL query)

APPLIES TO: NoSQL

Returns a datetime string representing the current UTC time minus a specified numeric offset.

Syntax

AGO(<date_time_part>, <numeric_expr>)

Arguments

Description
date_time_part A string representing a part of an ISO 8601 date format specification. This part is used to indicate which aspect of the date to modify by the related numeric expression.
numeric_expr The value to subtract from the current datetime.

Return types

Returns a string expression.

Examples

The following example shows various uses of the AGO function with different time parts. Assume the current datetime is 2024-10-14T14:20:30.6668888Z.

SELECT VALUE {
    "case1": AGO("yyyy", 1),
    "case2": AGO("yyyy", -1), 
    "case3": AGO("ss", 30),
    "case4": AGO("ms", 4)
}

[
    {
        "case1": "2023-10-14T14:20:30.6668888Z",
        "case2": "2025-10-14T14:20:30.6668888Z",
        "case3": "2024-10-14T14:20:00.6668888Z",
        "case4": "2024-10-14T14:20:30.6628888Z"
    }
]

Remarks

  • The ISO 8601 date format specifies valid date and time parts to use with this function:
    • Year: year, yyyy, yy
    • Month: month, mm, m
    • Day: day, dd, d
    • Hour: hour, hh
    • Minute: minute, mi, n
    • Second: second, ss, s
    • Millisecond: millisecond, ms
    • Microsecond: microsecond, mcs
    • Nanosecond: nanosecond, ns

Related content