SECOND

Returns the seconds part of a value. The argument must be a time, timestamp, time duration, or timestamp duration.

Example:

Assume column TIME_DUR has the value 153045.

   SECOND(TIME_DUR)

Returns the value 45.