select extract(hour from timestamp)
Advertisements
Let us now check the extract(hour) function with the following query.
Query
default> select extract(hour from timestamp '2016-08-11 17:17:00') as hour_field;
Result
The above query will generate the following result.
hour_field ------------------------------- 17.0
The query extracts an hour from the given timestamp.
apache_tajo_datetime_functions.htm
Advertisements