DateTimeToTimestamp (NoSQL query)
APPLIES TO: NoSQL
Converts the specified date and time to a numeric timestamp. The timestamp is a signed numeric integer that measures the milliseconds since the Unix epoch.
Syntax
DateTimeToTimestamp(<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 milliseconds that have elapsed since the Unix epoch (January 1, 1970).
Examples
The following example converts the date and time May 19, 2015 12:00 UTC to a timestamp.
SELECT VALUE {
timestamp: DateTimeToTimestamp("2015-05-19T12:00:00.0000000")
}
[
{
"timestamp": 1432036800000
}
]
Remarks
- This function returns
undefined
if the date and time isn't a valid ISO 8601 date and time string.