GetCurrentTimestamp (NoSQL query)
APPLIES TO: NoSQL
Returns the number of milliseconds that have elapsed since 00:00:00 Thursday, 1 January 1970
.
Syntax
GetCurrentTimestamp()
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
The following example shows how to get the current timestamp.
SELECT VALUE {
currentTimestamp: GetCurrentTimestamp()
}
[
{
"currentTimestamp": 1556916469065
}
]
Remarks
- This function is nondeterministic.
- The result returned is UTC (Coordinated Universal Time).
- This function doesn't use the index.
- If you need to compare values to the current time, obtain the current time before query execution and use that constant string value in the
WHERE
clause.
Related content
Atsauksmes
https://aka.ms/ContentUserFeedback.
Drīzumā: 2024. gada laikā mēs pakāpeniski pārtrauksim izmantot “GitHub problēmas” kā atsauksmju par saturu mehānismu un aizstāsim to ar jaunu atsauksmju sistēmu. Papildinformāciju skatiet:Iesniegt un skatīt atsauksmes par