Shulou(Shulou.com)06/01 Report--

This article will explain in detail the method of adding one hour to mysql at the current time. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Mysql's way to add an hour at the current time: you can use the date_add () function to do this. Specific methods such as: [update user set time1=now (), time2=date_add (NOW (), interval 1 MONTH)].

The DATE_ADD () function adds the specified time interval to the date.

Syntax:

DATE_ADD (date,INTERVAL expr type)

Sql statement:

Update user set time1=now (), time2=date_add (NOW (), interval 1 MONTH) where id=1; 's method of adding one hour to mysql at the current time is here. I hope the above content can be of some help and learn more knowledge. If you think the article is good, you can share it for more people to see.

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.