extract(quarter from timestamp)
Advertisements
Let us now check the extract(quarter) function with the following query.
Query
default> select extract(quarter from date '2016-08-11') as quarter_month;
Result
The above query will generate the following result.
quarter_month ------------------------------- 3.0
The query extracts a quarter of the month from the given month. The given month August comes under the third quarter of the year.
apache_tajo_datetime_functions.htm
Advertisements