select extract(isoyear from date)
Advertisements
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