extract(decade from date/timestamp)

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

Query

default> select extract(decade from date '2016-08-11') as decade;  

Result

The above query will generate the following result.

decade 
------------------------------- 
201.6 

The query extracts a decade from the specified date. One decade is equal to 10 years so, 2016 years equals to 201.6 decades.