You are viewing an older version of this section. View current production version.
Join the MemSQL Community Today
Get expert advice, develop skills, and connect with others.

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

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

Related Topics