VeloDB Cloud
SQL Manual
Functions
date-time-functions
seconds_add

seconds_add

Description

Syntax:

DATETIME SECONDS_ADD(DATETIME date, INT seconds)

This function adds the specified seconds to the given date.

date can be of DATE or DATETIME type, and the returned result is of DATETIME type.

Example

mysql> select seconds_add("2020-02-02 02:02:02", 1);
+---------------------------------------+
| seconds_add('2020-02-02 02:02:02', 1) |
+---------------------------------------+
| 2020-02-02 02:02:03                   |
+---------------------------------------+

Keywords

SECONDS_ADD