Converts a Unix timestamp to a Date data type.
Category: date
Syntax:
Returns: DateTimeColumn
Context Filtering: ✓ Yes
Parameters
| Name | Type | Required | Description |
|---|
number | number|column | ✓ Yes | A 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
Epoch start.
Result: 1970-01-01 00:00:00
Converts seconds since epoch.
Result: 2017-08-26 05:21:34 Last modified on March 13, 2026