GetCurrentTicks (NoSQL query)

APPLIES TO: NoSQL

Returns the number of 100-nanosecond ticks that have elapsed since 00:00:00 Thursday, 1 January 1970.

Syntax

GetCurrentTicks()

Return types

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

Examples

The following example returns the current time measured in ticks:

SELECT VALUE {
 currentTicks: GetCurrentTicks()
}

[
 {
 "currentTicks": 15973607943002652
 }
]

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

• System functions
• GetCurrentTicksStatic