SECONDS_ADD
Descriptionβ
The function adds or subtracts a specified number of seconds to/from a given datetime value and returns the resulting datetime.
Syntaxβ
SECONDS_ADD(<datetime>, <seconds>)
Parametersβ
| Parameter | Description |
|---|---|
<datetime> | Required. The input datetime value. Supports the DATETIME and DATE type. |
<seconds> | Required. The number of seconds to add or subtract. Supports integers (INT). Positive numbers add seconds, while negative numbers subtract seconds. |
Return Valueβ
- Returns a datetime value of the same type as the input
. - If
<datetime>is NULL, the function returns NULL. - If
<datetime>is an invalid date (e.g., 0000-00-00T00:00:00), the function returns NULL.
Examplesβ
SELECT SECONDS_ADD('2025-01-23 12:34:56', 30),SECONDS_ADD('2025-01-23 12:34:56', -30);
+---------------------------------------------------------------+----------------------------------------------------------------+
| seconds_add(cast('2025-01-23 12:34:56' as DATETIMEV2(0)), 30) | seconds_add(cast('2025-01-23 12:34:56' as DATETIMEV2(0)), -30) |
+---------------------------------------------------------------+----------------------------------------------------------------+
| 2025-01-23 12:35:26 | 2025-01-23 12:34:26 |
+---------------------------------------------------------------+----------------------------------------------------------------+
