extract(minute from timestamp )

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

Query

default> select extract(minute from time '17:25:15') as minutes;  

Result

The above query will generate the following result.

minutes 
------------------------------- 
25.0

The query extracts minute from the given time.