extract(day from date/timestamp)

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

Query

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

Result

The above query will generate the following result.

day 
------------------------------- 
11.0

The query extracts a day from the given day.