Loading

to_timestamp

Scalar function

Converts a UINT256 Unix timestamp (seconds since epoch) to a TIMESTAMP.

to_timestamp(UINT256)

Parameters

Name Type
unix_seconds UINT256

Returns

Name Type
timestamp TIMESTAMP
1
SELECT to_timestamp(1701388800::uint256); -- 2023-12-01 00:00:00
Notebook ready in readonly mode.