GetCurrentTimestampStatic (NoSQL query)
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.