extract(doy from date/timestamp)
Advertisements
Let us now check the extract(day of year) function with the following query.
Query
default> select extract(doy from date '2016-08-11') as dayofyear;
Result
The above query will generate the following result.
dayofyear ------------------------------- 224.0
The query extracts the day of the year.
apache_tajo_datetime_functions.htm
Advertisements