> 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.

# DateFromUnixUs

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

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

The UNIX timestamp is the number of seconds 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

```
DateFromUnixUs(microseconds)
```

Function arguments:

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

## Notes

* If **microseconds** is `Null`, the function returns `Null`.
* If your data is in seconds or milliseconds, you can use the [DateFromUnix](/docs/datefromunix) or [DateFromUnixMs](/docs/datefromunixms) functions.

## Examples

```
DateFromUnixUs(0)
```

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

```
DateFromUnixUs(1503724894000000)
```

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

```
DateFromUnixUs(-100000000000000)
```

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

## Related resources

* [DateFromUnixMs](/docs/datefromunixms)
* [DateFromUnix](/docs/datefromunix)
* [Date](/docs/date)
* <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>