Skip to main content

Add time interval

Add time interval to a date or datetime, return the result of date or datetime type.

Syntax

addYears(exp0, expr1)
addMonths(exp0, expr1)
addDays(exp0, expr1)
addHours(exp0, expr1)
addMinutes(exp0, expr1)
addSeconds(exp0, expr1)

Return Type

Date, Timestamp, depends on the input.

Examples

SELECT to_date(18875), addYears(to_date(18875), 2);
+---------------+-----------------------------+
| to_date(18875) | addYears(to_date(18875), 10) |
+---------------+-----------------------------+
| 2021-09-05 | 2023-09-05 |
+---------------+-----------------------------+

SELECT to_date(18875), addMonths(to_date(18875), 2);
+---------------+-----------------------------+
| to_date(18875) | addMonths(to_date(18875), 2) |
+---------------+-----------------------------+
| 2021-09-05 | 2021-11-05 |
+---------------+-----------------------------+

SELECT to_date(18875), addDays(to_date(18875), 2);
+---------------+---------------------------+
| to_date(18875) | addDays(to_date(18875), 2) |
+---------------+---------------------------+
| 2021-09-05 | 2021-09-07 |
+---------------+---------------------------+

SELECT to_dateTime(1630833797), addHours(to_dateTime(1630833797), 2);
+------------------------+-------------------------------------+
| to_dateTime(1630833797) | addHours(to_dateTime(1630833797), 2) |
+------------------------+-------------------------------------+
| 2021-09-05 09:23:17 | 2021-09-05 11:23:17 |
+------------------------+-------------------------------------+

SELECT to_dateTime(1630833797), addMinutes(to_dateTime(1630833797), 2);
+------------------------+---------------------------------------+
| to_dateTime(1630833797) | addMinutes(to_dateTime(1630833797), 2) |
+------------------------+---------------------------------------+
| 2021-09-05 09:23:17 | 2021-09-05 09:25:17 |
+------------------------+---------------------------------------+

SELECT to_dateTime(1630833797), addSeconds(to_dateTime(1630833797), 2);
+------------------------+---------------------------------------+
| to_dateTime(1630833797) | addSeconds(to_dateTime(1630833797), 2) |
+------------------------+---------------------------------------+
| 2021-09-05 09:23:17 | 2021-09-05 09:23:19 |
+------------------------+---------------------------------------+