IBM PureData System for Analytics, Version 7.1

The hour() function

The hour() function determines the hours value in the specified time.

You can also determine the hours value by using the IBM® Netezza® date_part() function.

Description

The hour() function has the following syntax:

int1 = hour(time input);

The input value specifies the time.

Returns an integer representation of the hour in the specified time. For example:

select hour ('01:12:55');
 HOUR
------
    1
(1 row)