IBM PureData System for Analytics, Version 7.1

The minute() function

The minute() function determines the minutes value in the specified time.

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

Description

The minute() function has the following syntax:

int1 = minute(time input);

The input value specifies the time.

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

select minute ('01:12:55');
 MINUTE
--------
     12
(1 row)