select extract(isodow from timestamp)

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.