# `TO_TIMESTAMP`

**Applies to:** ✅ Data 360 SQL ✅ Tableau Hyper API

Converts a Unix epoch, the number of seconds since 1970-01-01 00:00:00+00, to a timestamp.

## Syntax

```sql
to_timestamp(<double precision>)
```

## Arguments

### Required

- `<double precision>`: The number of seconds since 1970-01-01 00:00:00+00.

## Returns

Returns a `timestamp with time zone` value.

## Considerations

- To convert a timestamp back to an epoch value, use [`EXTRACT(EPOCH FROM ...)`](/docs/data/data-cloud-query-guide/references/dc-sql-reference/extract.md).
- This function converts a numeric epoch value to a timestamp. For the text-formatting form of `to_timestamp(text, text)`, which parses a formatted string into a timestamp, see [TO_TIMESTAMP](/docs/data/data-cloud-query-guide/references/dc-sql-reference/to-timestamp-string.md) in the Formatting Functions section.

## Examples

### Convert an Epoch to a Timestamp

Convert a Unix epoch value to a timestamp with time zone.

```sql
SELECT to_timestamp(1284352323) AS result;
```

Returns `2010-09-13 04:32:03+00`.

## Related Documentation

- [EXTRACT](/docs/data/data-cloud-query-guide/references/dc-sql-reference/extract.md)
- [TO_TIMESTAMP (Formatting Functions)](/docs/data/data-cloud-query-guide/references/dc-sql-reference/to-timestamp-string.md)
- [Date/Time Functions and Operators](/docs/data/data-cloud-query-guide/references/dc-sql-reference/datetime-func.md)