DateFromUnix

Convert a Unix timestamp to a Date data type.

See Sigma's Common Date Functions and Use Cases lab for information about date functions, including use cases and exercises.
The UNIX timestamp is the number of seconds (or milliseconds) elapsed since an absolute point in time, midnight of Jan 1 1970 in UTC time. (UTC is Greenwich Mean Time without Daylight Savings time adjustments.) Regardless of your time zone, the UNIX timestamp represents a moment that is the same everywhere.

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