Edit

GetCurrentTimestampStatic (NoSQL query)

  • Article

APPLIES TO: NoSQL

Returns the number of milliseconds that have elapsed since 00:00:00 Thursday, 1 January 1970.

Important

The static variation of this function only retrieves the timestamp once per partition. For more information on the non-static variation, see GetCurrentTimestamp

Syntax

GetCurrentTimestampStatic()

Return types

Returns a signed numeric value that represents the current number of milliseconds that have elapsed since the Unix epoch (00:00:00 Thursday, 1 January 1970).

Examples

This example uses a container with a partition key path of /pk. There are three items in the container with two items within the same logical partition, and one item in a different logical partition.

[
  {
    "id": "1",
    "pk": "A"
  },
  {
    "id": "2",
    "pk": "A"
  },
  {
    "id": "3",
    "pk": "B"
  }
]

This function returns the same static timestamp for items within the same partition. For comparison, the nonstatic function gets a new timestamp value for each item matched by the query.

SELECT
    i.id,
    i.pk AS partitionKey,
    GetCurrentTimestamp() AS nonStaticTimestamp,
    GetCurrentTimestampStatic() AS staticTimestamp
FROM
    items i

[
  {
    "id": "1",
    "partitionKey": "A",
    "nonStaticTimestamp": 1687977636235,
    "staticTimestamp": 1687977636232
  },
  {
    "id": "2",
    "partitionKey": "A",
    "nonStaticTimestamp": 1687977636235,
    "staticTimestamp": 1687977636232
  },
  {
    "id": "3",
    "partitionKey": "B",
    "nonStaticTimestamp": 1687977636238,
    "staticTimestamp": 1687977636237
  }
]

Note

It's possible for items in different logical partitions to exist in the same physical partition. In this scenario, the static date and time value would be identical.

Remarks

  • This static function is called once per partition.
  • Static versions of system functions only get their respective values once during binding, rather than execute repeatedly in the runtime as is the case for the nonstatic versions of the same functions.

See also