FromUnixTimestamp

The FromUnixTimestamp() function converts a unix timestamp to a date.

This function is NOT SQL compatible. For more information about SQL compatibility, see our documentation.

Returns the date represented by the given unix timestamp

Returns Unknown if one of the parameter values is unknown or outside the common valid date boundaries.

This function returns the date in the format settings of your project.

Syntax

FromUnixTimestamp(timestamp)

FromUnixTimestamp(1648637600) =>Result: Wednesday, March 30, 2022 10:53:20 AM

FromUnixTimestamp(unknowntimestamp) =>Result: unknown

Parameters

Name	Type	Required	Description
timestamp	numeric	☑️	A unix timestamp (seconds passed since JAN 01 1970)