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

See Also


Was this page helpful?
Yes No