# FROM\_UNIXTIME

Given an integer Unix timestamp, return the corresponding datetime.

## Syntax

```sql
FROM_UNIXTIME (epoch)

```

## Arguments

* epoch: an integer counting the seconds since 1 Jan 1970 UTC.
* format: a string containing format symbols as described in [DATE\_FORMAT](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/date-format.md).

## Return Type

A datetime object from the timezone set on the workspace.

## Examples

```sql
SELECT FROM_UNIXTIME(1234567890);

```

```output

+---------------------------+
| FROM_UNIXTIME(1234567890) |
+---------------------------+
| 2009-02-13 23:31:30       |
+---------------------------+

```

```sql
SELECT FROM_UNIXTIME(1234567890, '%M %D, %Y');

```

```output

+----------------------------------------+
| FROM_UNIXTIME(1234567890, '%M %D, %Y') |
+----------------------------------------+
| February 13th, 2009                    |
+----------------------------------------+

```

## Related Topics

* [UNIX\_TIMESTAMP](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/unix-timestamp.md)

***

Modified at: May 31, 2023

Source: [/cloud/reference/sql-reference/date-and-time-functions/from-unixtime/](https://docs.singlestore.com/cloud/reference/sql-reference/date-and-time-functions/from-unixtime/)

(An index of the documentation is available at /llms.txt)