date_part()

Let us now check the date_part(month,date) function with the following query.

Query

default> select date_part('month', date '2016-08-11') as month; 

Result

The above query will generate the following result.

month 
------------------------------- 
8.0

The query returns a month from the specified date.