Syntax
SECOND(time)
Purpose
SECOND() returns the seconds of time.
Examples
obclient> SELECT SECOND('18:20:17');
+--------------------+
| SECOND('18:20:17') |
+--------------------+
| 17 |
+--------------------+
1 row in set
OceanBase Hours · Aug 18 — Explore what’s next for databases in the AI era
OceanBase Hours · Aug 18 — Explore what’s next for databases in the AI era Join the Event ->
Meet OceanBase AI Lakebase, the unified database for operational data, real-time analytics, and AI.
Meet OceanBase AI Lakebase, the unified database for operational data, real-time analytics, and AI. Explore ->
OceanBase Hours · Aug 18 — Explore what’s next for databases in the AI era
OceanBase Hours · Aug 18 — Explore what’s next for databases in the AI era Join the Event ->
OceanBase Database
Download PDF
SECOND(time)
SECOND() returns the seconds of time.
obclient> SELECT SECOND('18:20:17');
+--------------------+
| SECOND('18:20:17') |
+--------------------+
| 17 |
+--------------------+
1 row in set