# Timezone Functions

#### <mark style="color:purple;">DATETIME(</mark>  \<expr>  \[,  \<timezone>]  <mark style="color:purple;">)</mark>

Returns the timestamp expression formatted to the given `timezone`. The default timezone is UTC.

```sql
> select datetime(datetime(current_timestamp, 'UTC'), 'Pacific/Samoa')
2023-01-05 22:27:20
```

#### <mark style="color:purple;">CONVERT\_TIMEZONE(</mark>  \<source\_timezone>, \<target\_timezone>, \<source\_timestamp>  <mark style="color:purple;">)</mark>

Returns the timestamp expression formatted to the given `timezone`. The default timezone is UTC.

<pre class="language-sql"><code class="lang-sql"><strong>> select convert_timezone('America/Los_Angeles','Africa/Cairo','2022-05-01 07:10:12');
</strong>2022-05-01 16:10:12
> select convert_timezone('America/Los_Angeles','2016-10-05 00:00:00');
2016-10-04 17:00:00

</code></pre>