SECOND function [Date and time]

Function

Returns a number from 0 to 59 corresponding to the second component of the given date/time value.

Syntax

SECOND ( datetime-expression )

Parameters

datetime-expression The date/time value.

Example

The following statement returns the value 5:

SELECT SECOND( '1998-07-13 08:21:05' ) FROM iq_dummy

Standards and compatibility