VeloDB Cloud
SQL Manual
SQL Functions
Date Functions
SECOND

Description

Returns second information in the time type, ranging from 0,59

The parameter is Date or Datetime or Time type

Syntax

INT SECOND(DATETIME date)

Example

mysql> select second('2018-12-31 23:59:59');
+-----------------------------+
| second('2018-12-31 23:59:59') |
+-----------------------------+
|                          59 |
+-----------------------------+

Keywords

SECOND