Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
DateTimeToTimestamp(<date_time>)
| Description | |
|---|---|
date_time |
A Coordinated Universal Time (UTC) date and time string in the ISO 8601 format YYYY-MM-DDThh:mm:ss.fffffffZ. |
Returns a signed numeric value, the current number of milliseconds that have elapsed since the Unix epoch (January 1, 1970).
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
}
]
- This function returns
undefinedif the date and time isn't a valid ISO 8601 date and time string.