Syntax
SECOND(Argument)
Description
The SECOND SQL scalar function returns the seconds part of a value.
The argument must be a time, timestamp.
The result of the function is a large integer.
If the argument can be null, the result can be null; if the argument is null, the result is the null value.
The result is the seconds part of the value, which is an integer between 0 and 59.
Example
Assume that the column RECEIVED (TIMESTAMP) has an internal value equivalent to 1988-12-25-17.12.30.000000.
SECOND(RECEIVED)
Returns the value 30.
List of SQL scalar functions by topic