# FromUnixTimestamp

{% hint style="info" %}
The **`FromUnixTimestamp()`** function converts a unix timestamp to a date. 

This function is NOT SQL compatible. For more information about SQL compatibility, see our [documentation](https://docs.wem.io/platform/wemreference/sql-compatibility).
{% endhint %}

{% hint style="success" %}
Returns the date represented by the given unix timestamp

Returns <mark style="color:red;">**`Unknown`**</mark> if one of the parameter values is unknown or outside the common valid date boundaries.
{% endhint %}

{% hint style="warning" %}
This function returns the date in the format settings of your project.&#x20;
{% endhint %}

### Syntax

<details>

<summary><code>FromUnixTimestamp(</code><mark style="color:blue;"><code>timestamp</code></mark><code>)</code></summary>

`FromUnixTimestamp(1648637600)`\
\=>*Result:* Wednesday, March 30, 2022 10:53:20 AM

`FromUnixTimestamp(unknowntimestamp)`\
\=>*Result: unknown*

</details>

### Parameters

<table><thead><tr><th width="181.70825474075613">Name</th><th width="150">Type</th><th width="150" align="center">Required</th><th width="248.15953250810662">Description</th><th data-hidden>Required?</th></tr></thead><tbody><tr><td><mark style="color:blue;"><code>timestamp</code></mark></td><td>numeric</td><td align="center"><span data-gb-custom-inline data-tag="emoji" data-code="2611">☑️</span></td><td>A unix timestamp (seconds passed since JAN 01 1970)</td><td>yes</td></tr></tbody></table>