SECOND

The SECOND function returns the seconds part of a value.

Syntax

SECOND( expression )

expression

An expression that can be a time, timestamp, or a valid character string representation of a time or timestamp.

Results

The returned result is an integer value in the range 0 to 59.

If the argument can be NULL, the result can be NULL; if the argument is NULL, the result is the NULLvalue.

Example

splice> VALUES( NOW(), HOUR(NOW), MINUTE(NOW), SECOND(NOW) );
1                            |2          |3          |4
----------------------------------------------------------------------------
2015-11-12 17:48:55.217      |17         |48         |55.217

1 row selected

See Also