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
Povratne informacije
https://aka.ms/ContentUserFeedback.
Uskoro: tokom 2024. postepeno ćemo ukidati probleme s uslugom GitHub kao mehanizam povratnih informacija za sadržaj i zamijeniti ga novim sistemom povratnih informacija. Za više informacija, pogledajtePošalјite i prikažite povratne informacije za