DateFromUnix
Convert a Unix-style timestamp (i.e., a number representing seconds since January 1, 1970) to a Date.
See Sigma's Common Date Functions and Use Cases lab for more information about date functions, including use cases and exercises.
Usage
DateFromUnix(number)
number (required) A number or column of numbers, each of which represent a Unix-style timestamp.
When you enter a number, the Date function behaves the same as DateFromUnix.
Examples
DateFromUnix(0)
- Returns 1970-01-01 00:00:00
DateFromUnix(1503724894)
- Returns 2017-08-26 05:21:34