IBM PureData System for Analytics, Version 7.1

The second() function

The second() function determines the seconds value in the specified time.

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

Description

The second() function has the following syntax:

int1 = second(time input);

The input value specifies the time.

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

select second ('01:12:55');
 SECOND
--------
    55
(1 row)