This browser is no longer supported.

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

Download Microsoft Edge More info about Internet Explorer and Microsoft Edge

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