DateTimeToTicks (NoSQL query)
APPLIES TO: NoSQL
Converts the specified DateTime to ticks. A single tick represents 100
nanoseconds or 0.000000001
of a second.
Syntax
DateTimeToTicks(<date_time>)
Arguments
Description | |
---|---|
date_time |
A Coordinated Universal Time (UTC) date and time string in the ISO 8601 format YYYY-MM-DDThh:mm:ss.fffffffZ . |
Return types
Returns a signed numeric value, the current number of 100
-nanosecond ticks that have elapsed since the Unix epoch (January 1, 1970).
s
Examples
The following example measures the ticks since the date and time May 19, 2015 12:00 UTC.
SELECT VALUE {
ticks: DateTimeToTicks("2015-05-19T12:00:00.0000000")
}
[
{
"ticks": 14320368000000000
}
]
Remarks
- This function returns
undefined
if the date and time isn't a valid ISO 8601 date and time string. - This function doesn't use the index.