> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://help.sigmacomputing.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://help.sigmacomputing.com/_mcp/server.

# DateFromUnix

> Use the Sigma DateFromUnix function to convert a Unix timestamp to the date data type in ISO date time format.

The **DateFromUnix** function converts a Unix timestamp to the [date data type](/docs/data-types-and-formats#date) in ISO date time format.

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. This is also known as the [Unix epoch](https://en.wikipedia.org/wiki/Unix_time), and represents an absolute time.

## Syntax

```
DateFromUnix(seconds)
```

Function arguments:

**seconds** (required) The number of seconds since 1970-01-01 00:00:00 UTC.

## Notes

* If **seconds** is `Null`, the function returns `Null`.
* This function is the same as `Date(seconds)`.
* If your data is in milliseconds or microseconds, you can use the [DateFromUnixMs](/docs/datefromunixms) or [DateFromUnixUs](/docs/datefromunixus) functions.

## Examples

```
DateFromUnix(0)
```

* Returns `1970-01-01 00:00:00`.

```
DateFromUnix(1503724894)
```

* Returns `2017-08-26 05:21:34`.

```
DateFromUnix(-100000000)
```

* Returns `1966-10-31 06:13:20`.

## Related resources

* [Date](/docs/date)
* [DateFromUnixMs](/docs/datefromunixms)
* [DateFromUnixUs](/docs/datefromunixus)
* <a href="https://quickstarts.sigmacomputing.com/guide/common_date_functions/index.html" target="_blank" rel="noopener noreferrer">
    Quickstart: Common date functions and use cases
  </a>