extract(decade from date/timestamp)
Advertisements
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.
apache_tajo_datetime_functions.htm
Advertisements