DateTimeToTicks (NoSQL query)

APPLIES TO: NoSQL

Converts the specified DateTime to ticks. A single tick represents 100 nanoseconds or 0.000000001of 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.