Skip to main content
Converts a Unix timestamp to a Date data type. Category: date Syntax:
DateFromUnix([number])
Returns: DateTimeColumn Context Filtering: ✓ Yes

Parameters

NameTypeRequiredDescription
numbernumber|column✓ YesA number or column of numbers representing a Unix timestamp (seconds or milliseconds).
Allowed Column Types: INT, FLOAT, DECIMAL

Validation

  • Minimum parameters: 1
  • Maximum parameters: 1

Examples

DateFromUnix(0)
Epoch start. Result: 1970-01-01 00:00:00
DateFromUnix(1503724894)
Converts seconds since epoch. Result: 2017-08-26 05:21:34
Last modified on March 13, 2026