MySQL TIMESTAMPADD() Function

Timestampadd() function in MySQL; In this tutorial, we will learn how to add the specified time of given date or DateTime value using MySQL TIMESTAMPADD() with the help of examples.

MySQL TIMESTAMPADD() Function

In MySQL, the TIMESTAMPADD () function allows you to add a specified amount to a date or a DateTime value.

Syntax

The basic syntax of this function is:

TIMESTAMPADD(unit,interval,datetime_expr)

Here, unit is the unit to add, interval is how many of the units to add, and datetime_expr is the initial date or datetime value.

We provide the unit argument see below:

MICROSECOND
SECOND
MINUTE
HOUR
DAY
WEEK
MONTH
QUARTER
YEAR

Example-1

In this example, we will add a day to the initial date.

SELECT TIMESTAMPADD(DAY, 1, '1999-12-31');

Output-1

+------------------------------------+
| TIMESTAMPADD(DAY, 1, '1999-12-31') |
+------------------------------------+
| 2000-01-01                         |
+------------------------------------+

Example-2

In this example, we will add a second to the initial date.

SELECT TIMESTAMPADD(SECOND, 1, '1999-12-31');

Output-2

+---------------------------------------+
| TIMESTAMPADD(SECOND, 1, '1999-12-31') |
+---------------------------------------+
| 1999-12-31 00:00:01                   |
+---------------------------------------+

The result is now a DateTime value in order to return the seconds part.

Example-3

In this example, we will add a microsecond to the initial date.

SELECT TIMESTAMPADD(MICROSECOND, 1, '1999-12-31');

Output-3

+--------------------------------------------+
| TIMESTAMPADD(MICROSECOND, 1, '1999-12-31') |
+--------------------------------------------+
| 1999-12-31 00:00:00.000001                 |
+--------------------------------------------+

Example-4

In this example, we will add a week to the initial date.

SELECT TIMESTAMPADD(WEEK,1,'2019-05-18');

Output-3

+--------------------------------------------+
| SELECT TIMESTAMPADD(WEEK,1,'2019-05-18')   |
+--------------------------------------------+
|  2019-05-25                                |
+--------------------------------------------+

Conclusion

Here, you have learned how to use MySQL TIMESTAMPDIFF() function with various examples.

MySQL TIMESTAMPADD() Function