# TO\_TIME
### Syntax
#### TO\_TIME(*numeric\_expression* int32) → time
* numeric\_expression: A Unix epoch timestamp.
**Examples**
{% code title="TO\_TIME example" %}
```sql
SELECT TO_TIME(1665131223)
-- 08:27:03
```
{% endcode %}
#### TO\_TIME(*numeric\_expression* int64) → time
* numeric\_expression: A Unix epoch timestamp.
**Examples**
{% code title="TO\_TIME example" %}
```sql
SELECT TO_TIME(1665131223)
-- 08:27:03
```
{% endcode %}
#### TO\_TIME(*string\_expression* varchar, *format* varchar, *replaceErrorWithNull* int32) → time
* string\_expression: The string from which to extract the time.
* format: String to specify format of the time.
* replaceErrorWithNull: If 0, the function will fail when given malformed input. If 1, the function will return NULL when given malformed input.
**Examples**
{% code title="TO\_TIME example" %}
```sql
SELECT TO_TIME('09:15:00.23232', 'HH:MI:SS', 1)
-- NULL
```
{% endcode %}
#### TO\_TIME(*string\_expression* varchar, *format* varchar) → time
* string\_expression: The string from which to extract the time.
* format: String to specify format of the time.
**Examples**
{% code title="TO\_TIME example" %}
```sql
SELECT TO_TIME('09:15:00', 'HH:MI:SS')
-- 09:15:00
```
{% endcode %}
#### TO\_TIME(*numeric\_expression* double) → time
* numeric\_expression: A Unix epoch timestamp.
**Examples**
{% code title="TO\_TIME example" %}
```sql
SELECT TO_TIME(1665131223.69)
-- 08:27:03
```
{% endcode %}
#### TO\_TIME(*numeric\_expression* float) → time
* numeric\_expression: A Unix epoch timestamp.
**Examples**
{% code title="TO\_TIME example" %}
```sql
SELECT TO_TIME(1665131223.69)
-- 08:27:03
```
{% endcode %}