TimestampToDateTime (NoSQL query)
APPLIES TO: NoSQL
Converts the specified timestamp to a date and time value.
TimestampToDateTime(<numeric_expr>)
Description | |
---|---|
numeric_expr |
A numeric expression. |
Obs!
For more information on the ISO 8601 format, see ISO 8601.
Returns a UTC date and time string in the ISO 8601 format YYYY-MM-DDThh:mm:ss.fffffffZ
.
The following example converts the ticks to a date and time value.
SELECT VALUE {
parseTicks: TimestampToDateTime(1597360794300),
parseUnixEpoch: TimestampToDateTime(0),
parseWindowsEpoch: TimestampToDateTime(-11644473600000)
}
[
{
"parseTicks": "2020-08-13T23:19:54.3000000Z",
"parseUnixEpoch": "1970-01-01T00:00:00.0000000Z",
"parseWindowsEpoch": "1601-01-01T00:00:00.0000000Z"
}
]
- This function returns
undefined
if the timestamp value specified is invalid.