select extract(hour from timestamp)

Let us now check the extract(hour) function with the following query.

Query

default> select extract(hour from timestamp '2016-08-11 17:17:00') as hour_field; 

Result

The above query will generate the following result.

hour_field 
------------------------------- 
17.0 

The query extracts an hour from the given timestamp.