second() function

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

You can also determine the seconds value by using the Netezza Performance Server date_part() function.

Syntax

The second() function has the following syntax:
int1 = second(time input);

The input value specifies the time.

Returns

The function returns an integer representation of the seconds value in the specified time.

Example

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