DateTimeFromParts (NoSQL query)

APPLIES TO: NoSQL

Returns a date and time string value constructed from input numeric values for various date and time parts.

Syntax

DateTimeFromParts(<numeric_year>, <numeric_month>, <numeric_day> [, <numeric_hour>]  [, <numeric_minute>]  [, <numeric_second>] [, <numeric_second_fraction>])

Arguments

Description
numeric_year A positive numeric integer value for the year. This argument is in the ISO 8601 format yyyy.
numeric_month A positive numeric integer value for the month. This argument is in the ISO 8601 format mm.
numeric_day A positive numeric integer value for the day. This argument is in the ISO 8601 format dd.
numeric_hour (Optional) An optional positive numeric integer value for the hour. This argument is in the ISO 8601 format hh. If not specified, the default value is 0.
numeric_minute (Optional) An optional positive numeric integer value for the minute. This argument is in the ISO 8601 format mm. If not specified, the default value is 0.
numeric_second (Optional) An optional positive numeric integer value for the second. This argument is in the ISO 8601 format ss. If not specified, the default value is 0.
numeric_second_fraction (Optional) An optional positive numeric integer value for the fractional of a second. This argument is in the ISO 8601 format fffffffZ. If not specified, the default value is 0.

Return types

Returns a UTC date and time string in the ISO 8601 format YYYY-MM-DDThh:mm:ss.fffffffZ.

Examples

The following example uses various combinations of the arguments to create date and time strings. This example uses the date and time April 20, 2017 13:15 UTC.

SELECT VALUE {
    constructMinArguments: DateTimeFromParts(2017, 4, 20),
    constructMinEquivalent: DateTimeFromParts(2017, 4, 20, 0, 0, 0, 0),
    constructAllArguments: DateTimeFromParts(2017, 4, 20, 13, 15, 20, 3456789),
    constructPartialArguments: DateTimeFromParts(2017, 4, 20, 13, 15),
    constructInvalidArguments: DateTimeFromParts(-2000, -1, -1)
}
[
  {
    "constructMinArguments": "2017-04-20T00:00:00.0000000Z",
    "constructMinEquivalent": "2017-04-20T00:00:00.0000000Z",
    "constructAllArguments": "2017-04-20T13:15:20.3456789Z",
    "constructPartialArguments": "2017-04-20T13:15:00.0000000Z"
  }
]

Remarks

  • If the specified integers would create an invalid date and time, the function returns undefined.