# HOUR

Extracts the hour of the day from the given datetime, zero-indexed.

Midnight is 0, 11PM is 23.

## Syntax

```
HOUR ( dateobj )

```

## Arguments

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

## Return Type

Integer

## Examples

```sql
SELECT HOUR('2009-02-13 23:31:30');

```

```output

+-----------------------------+
| HOUR('2009-02-13 23:31:30') |
+-----------------------------+
|                          23 |
+-----------------------------+

```

**Related Topics**

* [MINUTE](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/minute.md)
* [SECOND](https://docs.singlestore.com/db/v9.1/reference/sql-reference/date-and-time-functions/second.md)
* [Data Types](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-types.md)

***

Modified at: May 31, 2023

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

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