Edit

DateTimeToTicks (NoSQL query)

  • Article

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.

Note

For more information on the ISO 8601 format, see ISO 8601.

Return types

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

Note

For more information on the Unix epoch, see Unix time.

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.

Related content