ADDTIME()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns the sum of two TIME or DATETIME expressions.
USAGE
ADDTIME(timestamp, time)
Argument Name | Description |
|---|---|
| The starting |
| The amount of time to add |
DETAILS
ADDTIME() is a date-time function that returns the sum of two time expressions.
A NULL is returned if any argument is NULL.
EXAMPLES
SELECT ADDTIME('2020-02-28 12:34:56', '1 11:25:04');
+----------------------------------------------+
| ADDTIME('2020-02-28 12:34:56', '1 11:25:04') |
+----------------------------------------------+
| 2020-03-01 00:00:00 |
+----------------------------------------------+