Shulou(Shulou.com)05/31 Report--

This article mainly shows you "MySQL how to add or decrease date time", the content is easy to understand, clear, hope to help you solve your doubts, the following let the editor lead you to study and learn "MySQL how to add or decrease date time" this article.

Add / decrease date time

Command:

DATE_ADD (date,interval expr unit) DATE_SUB (date,interval expr unit)

Function: increase / decrease date time

Application scenario: the day before the current time, a few minutes ago. Often used for data statistics.

Example:

Mysql > select date_add (now (), interval 1 day) +-- + | date_add (now () Interval 1 day) | +-- + | 0-12-28 20:10:17 | +-- + 1 row in set (0.00 sec)

Where Date represents the date format, including:

2017-12-27 format such as now ().

Expr: indicates quantity.

Unit: represents a unit that supports milliseconds (microsecond), seconds (second), hours (hour), days (day), weeks (week), years (year), etc.

The above is all the content of the article "how to add or decrease date and time in MySQL". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.