TIMESTAMPADD() Function Examples – MySQL

TIMESTAMPADD() Function Examples – MySQL

How to add the specified time of given date or DateTime value, We will show you examples of this function.

In this tutorial, we are going to discuss MySql timestampadd() function with various 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.

If you have any questions or thoughts to share, use the comment form below to reach us.

Leave a Reply

Your email address will not be published. Required fields are marked *