How to add one hour to the current time in mysql

Mysql method to add one hour to the current time: You can use the date_add() function to achieve this. The specific method is: [update user set time1=now(), time2=date_add(NOW(), interval 1 MONTH)].

DATE_ADD() function adds a specified time interval to a date.

(Video tutorial recommendation: mysql video tutorial)

Grammar:

DATE_ADD(date,INTERVAL expr type)

(Related recommendation: mysql tutorial)

sql statement:

update user set time1=now(),time2=date_add(NOW(), interval 1 MONTH) where id=1;

The above is the detailed content of How to add one hour to the current time in mysql. For more information, please follow other related articles on the PHP Chinese website!