extract(day dow date/timestamp)



Let us now check the extract(day of week) function with the following query.

Query

default> select extract(dow from date '2016-08-11') as dayofweek;  

Result

The above query will generate the following result.

dayofweek 
------------------------------- 
4.0 

The query extracts the day of the week.

apache_tajo_datetime_functions.htm
Advertisements