# **TIME()**

## **Function Description**

Extracts the time part of the time or datetime expression `expr` and returns it as a string. If `expr` is `NULL`, `NULL` is returned.

## **Function Syntax**

```text
> TIME(expr)
```

## **Parameter definition**

| Parameters | Description |
| ---- | ---- |
| expr | Required parameters. The input value in date or datetime format that needs to be extracted |

## **Example**

```text
mysql> SELECT TIME('2003-12-31 01:02:03');
+--------------------------------+
| time(2003-12-31 01:02:03) |
+--------------------------------+
| 01:02:03 |
+--------------------------------+
1 row in set (0.01 sec)
```