ADD TIME INTERVAL
Add time interval function
Add a time interval to a date or timestamp, return the result of date or timestamp type.
Analyze Syntax
func.add_years(<exp0>, <expr1>)
func.add_quarters(<exp0>, <expr1>)
func.add_months(<exp0>, <expr1>)
func.add_days(<exp0>, <expr1>)
func.add_hours(<exp0>, <expr1>)
func.add_minutes(<exp0>, <expr1>)
func.add_seconds(<exp0>, <expr1>)
Analyze Examples
func.to_date(18875), func.add_years(func.to_date(18875), 2)
+---------------------------------+---------------------------------------------------+
| func.to_date(18875) | func.add_years(func.to_date(18875), 2) |
+---------------------------------+---------------------------------------------------+
| 2021-09-05 | 2023-09-05 |
+---------------------------------+---------------------------------------------------+
func.to_date(18875), func.add_quarters(func.to_date(18875), 2)
+---------------------------------+---------------------------------------------------+
| func.to_date(18875) | add_quarters(func.to_date(18875), 2) |
+---------------------------------+---------------------------------------------------+
| 2021-09-05 | 2022-03-05 |
+---------------------------------+---------------------------------------------------+
func.to_date(18875), func.add_months(func.to_date(18875), 2)
+---------------------------------+---------------------------------------------------+
| func.to_date(18875) | func.add_months(func.to_date(18875), 2) |
+---------------------------------+---------------------------------------------------+
| 2021-09-05 | 2021-11-05 |
+---------------------------------+---------------------------------------------------+
func.to_date(18875), func.add_days(func.to_date(18875), 2)
+---------------------------------+---------------------------------------------------+
| func.to_date(18875) | func.add_days(func.to_date(18875), 2) |
+---------------------------------+---------------------------------------------------+
| 2021-09-05 | 2021-09-07 |
+---------------------------------+---------------------------------------------------+
func.to_datetime(1630833797), func.add_hours(func.to_datetime(1630833797), 2)
+---------------------------------+---------------------------------------------------+
| func.to_datetime(1630833797) | func.add_hours(func.to_datetime(1630833797), 2) |
+---------------------------------+---------------------------------------------------+
| 2021-09-05 09:23:17.000000 | 2021-09-05 11:23:17.000000 |
+---------------------------------+---------------------------------------------------+
func.to_datetime(1630833797), func.add_minutes(func.to_datetime(1630833797), 2)
+---------------------------------+---------------------------------------------------+
| func.to_datetime(1630833797) | func.add_minutes(func.to_datetime(1630833797), 2) |
+---------------------------------+---------------------------------------------------+
| 2021-09-05 09:23:17.000000 | 2021-09-05 09:25:17.000000 |
+---------------------------------+---------------------------------------------------+
func.to_datetime(1630833797), func.add_seconds(func.to_datetime(1630833797), 2)
+---------------------------------+---------------------------------------------------+
| func.to_datetime(1630833797) | func.add_seconds(func.to_datetime(1630833797), 2) |
+---------------------------------+---------------------------------------------------+
| 2021-09-05 09:23:17.000000 | 2021-09-05 09:23:19.000000 |
+---------------------------------+---------------------------------------------------+
SQL Syntax
ADD_YEARS(<exp0>, <expr1>)
ADD_QUARTERs(<exp0>, <expr1>)
ADD_MONTHS(<exp0>, <expr1>)
ADD_DAYS(<exp0>, <expr1>)
ADD_HOURS(<exp0>, <expr1>)
ADD_MINUTES(<exp0>, <expr1>)
ADD_SECONDS(<exp0>, <expr1>)
Return Type
DATE, TIMESTAMP, depends on the input.
SQL Examples
SELECT to_date(18875), add_years(to_date(18875), 2);
+----------------+------------------------------+
| to_date(18875) | add_years(to_date(18875), 2) |
+----------------+------------------------------+
| 2021-09-05 | 2023-09-05 |
+----------------+------------------------------+
SELECT to_date(18875), add_quarters(to_date(18875), 2);
+----------------+---------------------------------+
| to_date(18875) | add_quarters(to_date(18875), 2) |
+----------------+---------------------------------+
| 2021-09-05 | 2022-03-05 |
+----------------+---------------------------------+
SELECT to_date(18875), add_months(to_date(18875), 2);
+----------------+-------------------------------+
| to_date(18875) | add_months(to_date(18875), 2) |
+----------------+-------------------------------+
| 2021-09-05 | 2021-11-05 |
+----------------+-------------------------------+
SELECT to_date(18875), add_days(to_date(18875), 2);
+----------------+-----------------------------+
| to_date(18875) | add_days(to_date(18875), 2) |
+----------------+-----------------------------+
| 2021-09-05 | 2021-09-07 |
+----------------+-----------------------------+
SELECT to_datetime(1630833797), add_hours(to_datetime(1630833797), 2);
+----------------------------+---------------------------------------+
| to_datetime(1630833797) | add_hours(to_datetime(1630833797), 2) |
+----------------------------+---------------------------------------+
| 2021-09-05 09:23:17.000000 | 2021-09-05 11:23:17.000000 |
+----------------------------+---------------------------------------+
SELECT to_datetime(1630833797), add_minutes(to_datetime(1630833797), 2);
+----------------------------+-----------------------------------------+
| to_datetime(1630833797) | add_minutes(to_datetime(1630833797), 2) |
+----------------------------+-----------------------------------------+
| 2021-09-05 09:23:17.000000 | 2021-09-05 09:25:17.000000 |
+----------------------------+-----------------------------------------+
SELECT to_datetime(1630833797), add_seconds(to_datetime(1630833797), 2);
+----------------------------+-----------------------------------------+
| to_datetime(1630833797) | add_seconds(to_datetime(1630833797), 2) |
+----------------------------+-----------------------------------------+
| 2021-09-05 09:23:17.000000 | 2021-09-05 09:23:19.000000 |
+----------------------------+-----------------------------------------+
Last modified June 12, 2024 at 9:53 PM EST: updating datetime functions (f087f54)