This browser is no longer supported.

Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.

Converts the specified timestamp to a date and time value.

Syntax

TimestampToDateTime(<numeric_expr>)
Arguments
Return types
Returns a UTC date and time string in the ISO 8601 format YYYY-MM-DDThh:mm:ss.fffffffZ.
Examples
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"
Remarks
This function returns undefined if the timestamp value specified is invalid.
Related content
System functions
TicksToDateTime
			Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.		

        
Submit and view feedback for
                    This product