extract(doy from date/timestamp)

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.