EXTRACTHOUR

This function returns the hour part of the input timestamp value. Also see EXTRACT.

Syntax

SELECT EXTRACT(HOUR FROM TIMESTAMP timestamp_expr);