select extract(isoyear from date)



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

Query

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

Result

The above query will generate the following result.

year 
------------------------------- 
2016.0 

The query extracts ISO year from the specified date.

apache_tajo_datetime_functions.htm
Advertisements