Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

SECOND

Extracts the seconds of the minute from the given datetime.

Syntax

SECOND ( dateobj )

Arguments

  • dateobj: a valid date, datetime, time, or parsable datetime string.

Return Type

Integer

Examples

select second('2009-02-13 23:31:30');
+-------------------------------+
| second('2009-02-13 23:31:30') |
+-------------------------------+
|                            30 |
+-------------------------------+

Related Topics