select extract(isodow from timestamp)
Advertisements
Let us now check the extract(isodow) function with the following query.
Query
default> select extract(isodow from timestamp '2016-08-11 17:22:00') as dayofweek;
Result
The above query will generate the following result.
dayofweek ------------------------------- 4.0
The query extracts ISO day of the week.
apache_tajo_datetime_functions.htm
Advertisements