# TIME

Extracts the time part from a datetime object.

## Syntax

```
TIME (dateobj)

```

## Arguments

* dateobj: a valid date, datetime, time, or parsable datetime string

## Return Type

Time object. If dateobj is not a valid time, returns NULL.

## Examples

```sql
SELECT TIME('2019-01-01 05:06');

```

```output

+--------------------------+
| TIME('2019-01-01 05:06') |
+--------------------------+
| 05:06:00                 |
+--------------------------+

```

***

Modified at: May 31, 2023

Source: [/db/v9.1/reference/sql-reference/date-and-time-functions/time/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/time/)

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